Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Check with KeepChar function
KeepChar(FieldName,'0123456789')
Celambarasan
Hi,
Check with KeepChar function
KeepChar(FieldName,'0123456789')
Celambarasan
check this one
phone number
02/0383838
010 0983823'
08 - 0292827'
what if there is single code like above one. how could we avoid ..