Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
PurgeChar(FieldName, ' -') as FieldName
Or you can do this
Replace(Replace(FieldName, ' ', ''), '-', '') as FieldName
This worked perfectly, thanks!