Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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
Specialist
Specialist

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
Specialist
Specialist

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!!