Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello ,
Is it possible to know how to extract a sub string in a new field for the following scenario :
The content of my field is only numeric or numeric following by alphabetical characters
example : 12345 result will be 12345
12345ABC result will be 12345
12345Z result will be 12345
Thanks for your help
Thierry
try with keepchar function
KeepChar('12345ABC', 1234567890)
KeepChar(yourfield, 1234567890)