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

Announcements
Discover the Trends Shaping AI in 2026: Register Here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Trim like?

Hi

I'm looking for a function:

my data is in this format: 32-GH-47 and i would like to quit the '-' caracter.

As well, how do i quit the space in a middle of '26 AK 25' ?

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

see QV help and look for PURGECHAR

purgechar ( 'a1b2c3','123' ) and you will get 'abc'

Good luck!

Rainer

View solution in original post

2 Replies
Not applicable
Author

Hi,

see QV help and look for PURGECHAR

purgechar ( 'a1b2c3','123' ) and you will get 'abc'

Good luck!

Rainer

Not applicable
Author

thanks