Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script

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.

3 Replies
sivarajs
Specialist II
Specialist II

try this while loading

 

KeepChar

(Fieldname,'0123456789')  as field1

senpradip007
Specialist III
Specialist III

Re: Script

Hi Manish try this one at the time of loading.

Keepchar(Fieldname,'0123456789') as Fieldname

brenner_martina
Partner - Specialist II
Partner - Specialist II

Or you can use the function:

If( IsNum(filedname), fieldname) As fieldname

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

Greetings from Munich

Martina