topic Re: HOW USE CHR IN worksheets in QlikView

HOW USE CHR IN worksheets

Anonymous — Fri, 13 Jun 2014 13:12:42 GMT

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.

Re: HOW USE CHR IN worksheets

ThornOfCrowns — Fri, 13 Jun 2014 13:18:21 GMT

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

Re: HOW USE CHR IN worksheets

its_anandrjs — Fri, 13 Jun 2014 13:19:00 GMT

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

Re: HOW USE CHR IN worksheets

Anonymous — Fri, 13 Jun 2014 13:24:09 GMT

Hello Anand !

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

Re: HOW USE CHR IN worksheets

Anonymous — Fri, 13 Jun 2014 13:54:09 GMT

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".