I am trying to find a good way to strip all non numeric characters from a string. This is for a phone number that I read from a flat file and this field could be formatted in different ways
Is it possible only by examining each character in turn or else is there a replace/extract function that I could use with better effect.
I thought I might use the EREPLACE function but I will have to check for every possible character to strip out. I'm hoping there is a way to either strip the non-numeric chars leaving just the digits in the string or go the other way and extract the numeric chars from the string.