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 field1
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
Retrieving data ...