How replace/substitue

[andyrebs]

Hello,

I have a csv file with a Telephone field filled as below:

PhoneNumber

02/0383838

010 0983823

08 - 0292827

...

I would like to load the filed as

PhoneNumber

020383838

0100983823

080292827

..

Thanks

Andrea

[CELAMBARASAN · Accepted solution]

Hi,

     Check with KeepChar function

     KeepChar(FieldName,'0123456789')

Celambarasan

[andyrebs]

Perfect!

I have seen also this discussion

Phone numbers on different formats. How to match?

Thank you!

[#4]

check this one

phone number

02/0383838

010 0983823'

08 - 0292827'

what if there is single code like above one. how could we avoid ..