how to find numbers from alphanumeric field

rishi_smhs

hiii,
can anyone tell me that how to find numbers from alphanumeric field in navision.

deV.ch

If you want to test if a specific position in a Text Variable or Field is Numeric then use this:

IsNumeric := EVALUATE(TempInt, YourNAVField[Position]);

If you want to know if the whole field is numeric then just leave away the [Position]

mohana_cse06

you can try

test := 'abcd12fs451af44';
newtest := DELCHR(test,'=',DELCHR(test,'=','1|2|3|4|5|6|7|8|9|0'));

kriki

mohana_cse06 wrote:

you can try

test := 'abcd12fs451af44';
newtest := DELCHR(test,'=',DELCHR(test,'=','1|2|3|4|5|6|7|8|9|0'));

Don't use the | in the string. It means that you also delete that character in the inner DELCHR and thus NOT in the outer DELCHR.

Use this:

test := 'a|bc|d12|fs451af44';
newtest := DELCHR(test,'=',DELCHR(test,'=','1234567890'));

mohana_cse06

kriki wrote:

mohana_cse06 wrote:

you can try

test := 'abcd12fs451af44';
newtest := DELCHR(test,'=',DELCHR(test,'=','1|2|3|4|5|6|7|8|9|0'));

Don't use the | in the string. It means that you also delete that character in the inner DELCHR and thus NOT in the outer DELCHR.

Use this:

test := 'a|bc|d12|fs451af44';
newtest := DELCHR(test,'=',DELCHR(test,'=','1234567890'));

Thanks for correcting :thumbsup: