In between for text format

Comments

• Options

  landlord Member Posts: 18

  2013-11-25

  Try something like this:
  
  
  Chr := 'A';
  EVALUATE(AsciiValue,FORMAT(Chr,0,'<NUMBER>'));
  IF AsciiValue >= 65 AND AsciiValue <= 74 THEN
  RETURN Group1
  ELSE IF AsciiValue >= 75 AND AsciiValue <= 83 THEN
  Return GROUP2
  ELSE IF AsciiValue >= 84 AND AsciiValue <= 90 THEN
  Return GROUP3;
  ELSE ERROR('Wrong character %1', Chr);

  0
• Options

  casanova Member Posts: 194

  2013-11-26

  landlord wrote:

  Try something like this:
  
  
  Chr := 'A';
  EVALUATE(AsciiValue,FORMAT(Chr,0,'<NUMBER>'));
  IF AsciiValue >= 65 AND AsciiValue <= 74 THEN
  RETURN Group1
  ELSE IF AsciiValue >= 75 AND AsciiValue <= 83 THEN
  Return GROUP2
  ELSE IF AsciiValue >= 84 AND AsciiValue <= 90 THEN
  Return GROUP3;
  ELSE ERROR('Wrong character %1', Chr);

  
  hi Landlord
  but this grouping thing is dynamic
  how do i filter in records
  thx

  0
• Options

  landlord Member Posts: 18

  2013-11-26

  I am not sure that I completely understand your question.
  Can you post a couple of rows from your table and explain in more details what you want to accomplish?
  
  Thanks.

  0
• Options

  Kishorm Member Posts: 921

  2013-11-27

  Assuming the Groups table has fields named Group, StartLetter and EndLetter then something like...
  
  SETFILTER(StartLetter, '..%1', SearchLetter);
  SETFILTER(EndLetter, '%1..', SearchLetter);

  0