Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewaf
Creator
Creator

Export TXT: why a line is splitted on 2 rows

Hi,

anyone knows why with a macro that export on TXT a table, some lines are splitted in 2 rows ? 

Thank you

 

newline.PNG

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

It's a carriage return respectively chr(13) - see: http://www.virtualuniversity.ch/software/ascii/0.html.

Just try: replace(Text, chr(13), '')

- Marcus

View solution in original post

3 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

Quite probably is there any extra line-break char included within your data. Just use another editor like notepad++ and switch on the option to display all chars. Usually it's the best to adjust the data before you export them - probably with a replace like:

replace(Text, chr(10) & chr(10), chr(10))

Before just starting with trial & error like this example take a look in the data to know which chars cause this issue.

- Marcus

qlikviewaf
Creator
Creator
Author

indeed there's a CR  ... WHAT IS THIS? how can be removed before exporting?

 

Cattura.PNG

marcus_sommer
MVP & Luminary
MVP & Luminary

It's a carriage return respectively chr(13) - see: http://www.virtualuniversity.ch/software/ascii/0.html.

Just try: replace(Text, chr(13), '')

- Marcus

View solution in original post