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

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

HOW USE CHR IN worksheets

Good day gentlemen!

I'm looking for a while in the community on how to make my text object recognizes a command that I put into my spreadsheet.

To be more clear:

I'm reading a spreadsheet and want the "Instruction" column has many steps, and between these steps I would use the Chr (13) expression, to skip the lines, but when put to display this column it does not recognize the commands used, and show as if they were purchased.

Does anyone know if you can use it?

Thank you.

Labels (1)
4 Replies
ThornOfCrowns
Specialist II
Specialist II

I don't know if you can use SubStringCount to check for a carriage return, but that would be my first thought.

its_anandrjs
Champion III
Champion III

what is your script can you post here and where you use it

Anonymous
Not applicable
Author

Hello Anand !

I have a script ready. But I know I'll have to use that.

Anonymous
Not applicable
Author

James,

But in fact this expression only brings me the amount that the character is written.

I need it to recognize the name of the spacing in the "load".