Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
schmidtkm37
Contributor III
Contributor III

Remove spaces and hyphens

Hi all,

I have a dimension with data that looks like this: 

2 000 15 6

2 05-152 6

1-46580-00

I want to condense those numbers into this:

2000156

2051526

14658000

What is the best way to do that? Does Qlik Sense support regular expressions?

 

Thanks,

 

Kevin

1 Solution

Accepted Solutions
sunny_talwar

Try this

PurgeChar(FieldName, ' -') as FieldName

View solution in original post

3 Replies
sunny_talwar

Try this

PurgeChar(FieldName, ' -') as FieldName
sunny_talwar

Or you can do this

Replace(Replace(FieldName, ' ', ''), '-', '') as FieldName
schmidtkm37
Contributor III
Contributor III
Author

This worked perfectly, thanks!