Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Perfect Surendar. Many thanks.