Page 1 of 1

extract a text

Posted: December 19th, 2013, 7:49 pm
by CRISPAN
i have a batch programm and I need to extract text from a 6 digit the last 2 digits and then use it to make a filter

for example, a field with a list of 6 digit numbers only filter that end with the number 50

Re: extract a text

Posted: December 20th, 2013, 1:14 am
by khurshid.arshad
Dear Crispan;

use this link to extract text.

http://csprousers.org/forum/viewtopic.php?f=1&t=504

If this link is not working then see 20th topic on page 7 under "Entry" option.



a.

Re: extract a text

Posted: December 20th, 2013, 5:59 pm
by Gregory Martin
If the field is numeric your condition can be:
VAL % 100 = 50
If the field is alpha:
VAL[5:2] = "50"