Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Way to retain Leading number of "spaces" from excel data while loading . If any ?

Hello ,

We all have been trimming unnecessary spaces using trim functions . But i have a requirement where i want to load a column where i need to retain space (number of times space bar pressed , before actual data) .
I am not aware of function to do it  ?

Retaining Spaces.PNG

 

Thanks in advance . 

 

4 Replies
Highlighted
Specialist
Specialist

Re: Way to retain Leading number of "spaces" from excel data while loading . If any ?

Hi Sunny Bhai ,  

Can this be achieved in qlik ?

@sunny_talwar 

 

 

Highlighted

Re: Way to retain Leading number of "spaces" from excel data while loading . If any ?

Have you looked at this?

Verbatim 

Highlighted

Re: Way to retain Leading number of "spaces" from excel data while loading . If any ?

Capture.png

Highlighted
Specialist
Specialist

Re: Way to retain Leading number of "spaces" from excel data while loading . If any ?

Thank You Bhai ..