Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
badamsrinivas
Contributor II
Contributor II

Interview question

 
Labels (1)
3 Replies
badamsrinivas
Contributor II
Contributor II
Author

Below is Interview question, PFB details

Inline * load[

Name
er#io*io
uig&^jk
hjkg$%&

];

How can i remove the symbols from above filed, user need only characters to be with that Name filed? how do you achieve it?

Iswarya_
Creator
Creator

Hi, 

You can use Keepchar() to specify the charcters which are needed

anat
Master
Master

its not a" inline * load",the format is "load * inline"

load Name,keepchar(Name,'abcdefghijklmnopqrstuvwxyz');

load * inline

[

Name
er#io*io
uig&^jk
hjkg$%&

];