Script

[#1]

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.

[sivarajs]

try this while loading

KeepChar

(Fieldname,'0123456789')  as field1

[senpradip007]

Re: Script

Hi Manish try this one at the time of loading.

Keepchar(Fieldname,'0123456789') as Fieldname

[brenner_martina]

Or you can use the function:

If( IsNum(filedname), fieldname) As fieldname

or If( IsText(...), ...) As ...

Greetings from Munich

Martina