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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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 ];