Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
Kain_F
Contributor III
Contributor III

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',':,;@')

 

Kain_F
Contributor III
Contributor III
Author

@PradeepK  super, thanks 😊