Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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 😊