Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have excel sheet with 5 columns every column has some text and numbers , i want to remove the text from every column before loading it.
try this while loading
KeepChar
(Fieldname,'0123456789') as field1Re: Script
Hi Manish try this one at the time of loading.
Keepchar(Fieldname,'0123456789') as Fieldname
Or you can use the function:
If( IsNum(filedname), fieldname) As fieldname
or If( IsText(...), ...) As ...
Greetings from Munich
Martina