Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need to identify a specific number that matches to certain criteria. This criteria is that is must be 10 digits long and the third last number must be a three (3).
e.g.
123456789
1541162347
98765327
The second one should be a match and will return 'YES' in a new field.
Can anyone assist?
maybe this
if(len(FIELD) = 10 And Isnumeric(FIELD) AND mid(FIELD,8,1)=3, 'YES', 'NO') as NEW_FIELD
if(len(your_field) = 10 and mid(right(your_field,3),1) = '3' and isNumeric(your_field),1,0)
number like '???????3??'
one example:
table1:
LOAD *,
If(number like '???????3??','Yes','No') as Flag
INLINE [
number
123456789
1541162347
98765327
];
hope this helps
regards
Marco