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: 
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