Substring question

[Anonymous]

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

[maxgro]

try with keepchar function

KeepChar('12345ABC', 1234567890)

KeepChar(yourfield, 1234567890)