Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
camilo
Contributor III
Contributor III

Delette Spaces

How can I delette spaces when I´m Loading some info?

For example I have a table with the following fileld:

1 2 3

a a a

And I want to load:

123

aaa

Thanks!

1 Solution

Accepted Solutions
mike_garcia
Luminary Alumni
Luminary Alumni

Hi!

You can use the Replace function...

Replace(FieldName, ' ', '')

PurgeChar() might do it as well.

Mike

Miguel García
Qlik Expert, Author and Trainer

View solution in original post

2 Replies
mike_garcia
Luminary Alumni
Luminary Alumni

Hi!

You can use the Replace function...

Replace(FieldName, ' ', '')

PurgeChar() might do it as well.

Mike

Miguel García
Qlik Expert, Author and Trainer
camilo
Contributor III
Contributor III
Author

Thanks, Replace did the work!!