Export TXT: why a line is splitted on 2 rows

[qlikviewaf]

Hi,

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

Thank you

[marcus_sommer]

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]

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

[marcus_sommer · Accepted solution]

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

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

- Marcus