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

Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
shekhar_analyti
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 . 

 

5 Replies
shekhar_analyti
Specialist
Specialist
Author

Hi Sunny Bhai ,  

Can this be achieved in qlik ?

@sunny_talwar 

 

 

sunny_talwar

Have you looked at this?

Verbatim 

sunny_talwar

Capture.png

shekhar_analyti
Specialist
Specialist
Author

Thank You Bhai .. 

KD_
Contributor III
Contributor III

Straight genius