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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-03-15 10:13 AM

Trim all fields on load

I need to trim all fields I receive in my load script.

Unfortunately LOAD trim(*) as * is not an option.

At this time I need to adjust the script for many field from 'fieldname' to trim('fieldname') as 'fieldname'. A tedious work.

I've looked around for some smart search and replace editor but no luck.

Any ideas?

2,516 Views
0 Likes
3 Replies
amars
Specialist
Specialist
‎2011-03-15 10:19 AM

Try using RTrim(LTrim(FieldName) as FieldName

Thanks...

462 Views
0 Likes
Not applicable
‎2011-03-15 11:59 AM
Author

In response to amars

Sorry, but how does that Help me?

462 Views
0 Likes
Not applicable
‎2012-06-29 11:21 AM
Author

In response to

Have you found any ideas? I have a similar issue that I need to trim only the right for every single field in my script. I know currently there is Verbatim that can be set to keep or remove trailing and leading spaces, but I have not seen any options to do only one side.

462 Views
0 Likes