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
extract a text
-
- Posts: 572
- Joined: July 9th, 2012, 11:32 am
- Location: Islamabad, Pakistan
Re: extract a text
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.
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.
-
- Posts: 1801
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: extract a text
If the field is numeric your condition can be:
VAL % 100 = 50
If the field is alpha:VAL[5:2] = "50"