Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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!