Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Export TXT: why a line is splitted on 2 rows

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
Highlighted
MVP & Luminary
MVP & Luminary

Re: Export TXT: why a line is splitted on 2 rows

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

Highlighted
Creator
Creator

Re: Export TXT: why a line is splitted on 2 rows

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

 

Cattura.PNG

Highlighted
MVP & Luminary
MVP & Luminary

Re: Export TXT: why a line is splitted on 2 rows

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