Removeing character values from alphanumeric field

[montubhardwaj]

Hi Community,

I have a problem with the alphanumeric values coming from the field. I want to remove character values from this field and retain only the numeric part of it.

For example, I have a field say Dept_Id. Below are the values coming out of it.

AA23546

SAT66458

J646578

BDYU15

etc.

I want to have the values like 23546,66458,646578,15 out of the above values. Please note that number of characters are varying.

Any help is very much appreciated.

[#2 · Accepted solution]

Hi Sharma

you can use either purgechar or keepchar functions in qv here is the code for tht

keepchar(Dept_Id,1234567890) as Dept_Id ..

This will remove alphabets and keep the numbers

[montubhardwaj]

Perfect Surendar. Many thanks.