Q:
Extracting Only Numbers from String in AS400
I have thousands of address records in AS400 and need to extract only the numbers from the records.
Example:
5770 South 900 West #2
and I want it to look like
57709002
Is there any way to do this in AS400? Thank you.
Example:
5770 South 900 West #2
and I want it to look like
57709002
Is there any way to do this in AS400? Thank you.
ASKED:
Jan 7 2009 4:15 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
- the RPG routine might look something like this.
NumFld = blanks
For X = 1 to 80 <-- length of address field
StringChar = %subst(AddFld : X : 1);
if StringChar >= '0' and StringChar <= '9'
Eval NumFld = %Trim(NumFld) + StringChar
endif
EndFor
