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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to remove blank spaces between lines or between strings.

Hi,

This is extension to blog .....Replace function: Find Multiple strings and replace to blank

After I replace strings, my table field has lot of blank spaces. Is there any way I can remove those? Please help.

Sample in the file:

///////////////////////////////////////////////////////////

    c c  1c

'02'00. '01

'02'01. '01

'02'02. '01

//////////////////////////////////////////////////////////////

My desired result is below...

////////////////////////////////////////////////////////////

c c  1c

'02'00. '01

'02'01. '01

'02'02. '01

////////////////////////////////////////////////////////////////

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

map1:

mapping load * inline [

x, y

happy, ''

dinner, ''

] ;

Directory;

Load * Where Len(Trim(Changed)) > 0;

LOAD

mapsubstring('map1',SalesOrder_Text) as Changed;

Load * Inline [

SalesOrder_Text

happy

dinner  

aaxxyyy

bcd

hello ];

View solution in original post

1 Reply
anbu1984
Master III
Master III

map1:

mapping load * inline [

x, y

happy, ''

dinner, ''

] ;

Directory;

Load * Where Len(Trim(Changed)) > 0;

LOAD

mapsubstring('map1',SalesOrder_Text) as Changed;

Load * Inline [

SalesOrder_Text

happy

dinner  

aaxxyyy

bcd

hello ];