Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Kain_F
Contributor II
Contributor II

Purgechar(field,'character') multiple characters

Hi community,

I have the following issue:

For an assignement I need to clean a dataset. The data in my field looks like this

Table:

Load* Inline[

Text

':text, text;  text @ text'

'/text% text= text'

]

 

As you can see I have multiple characters I would like to purge.

Do you guys know a way to do this without nesting X-amount purgechar(field,'character') functions?

 

Kind regards  🙂

1 Solution

Accepted Solutions
PradeepK
Creator II
Creator II

2nd argument takes multiple characters.. you don't have to do any nesting 

PurgeChar(':text, text;  text @ text',':,;@')

 

View solution in original post

2 Replies
PradeepK
Creator II
Creator II

2nd argument takes multiple characters.. you don't have to do any nesting 

PurgeChar(':text, text;  text @ text',':,;@')

 

View solution in original post

Kain_F
Contributor II
Contributor II
Author

@PradeepK  super, thanks 😊