Phone Number Formatting Question

[#1]

I'm importing phone numbers that have no standard formating.  Some have (XXX), some have +999, some have "-", etc.  I found the purgeChr() function, which helps immensely.  However, many of the numbers have extensions, such as....

1234567890ext999 or

1234567890x444

Is it possible to remove everything after (and including) the "e" or the "x" in the examples above?

Thanks,    Dan

[jagan]

Hi,

Did you tried the solution I provided earlier using KeepChar()? 

LOAD

*,

KeepChar(PhoneNumber, '1234567890exEX') AS PhoneNumber_Formatted

FROM DataSource;

Regards,

Jagan.

[#3]

Yes, KeepChar is a lot simpler naming a dozen nums/chars to keep rather than all those to purge.  Thanks!

[jagan]

Hi Dan,

If you got the answer you can close this thread by marking Correct and Useful answers to the posts which helps you in finding the solution.

Regards,

Jagan.