Remove spaces and hyphens

[schmidtkm37]

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

[sunny_talwar · Accepted solution]

Try this

PurgeChar(FieldName, ' -') as FieldName

[sunny_talwar]

Or you can do this

Replace(Replace(FieldName, ' ', ''), '-', '') as FieldName

[schmidtkm37]

This worked perfectly, thanks!