CSV Emitter issue when opening with notepad

Hi all,
i have bee having an issue when trying to open a csv file i created, using the CSV plugin provided on this site, in notepad.
the return (\n) character at the end of every row doesn't seem to be working as a result the whole file appears in a line and it is stopping a process that requires that file.

Thanks

Find more posts tagged with

Comments

mwilliams

I see the same in Notepad when I export the data to CSV from the web viewer. You may have to edit the emitter. If I figure anything else out, I'll post in here. Hopefully someone else has run into this issue before and knows!

magic_bern

Thank you very much for the hint,
i did have a look at the CSVTags.java file in the emitter that was provided and changed the endrow tag from
public static final String TAG_CR = "\n" ; to public static final String TAG_CR = "\r\n" ; then packaged it and it has did the trick.
found somewhere that \r is carriage return and \n is line feed and the combinasion give a new line in window.

Thanks

mwilliams

Awesome! This would possibly be a good tip to put in the devShare for others to find! If you have the time and want to detail what you had to do a little and maybe attach the changed emitter file, that'd be great. You'd also be entered in the <a class='bbc_url' href='http://www.birt-exchange.org/org/wiki/index.php?title=DevShare_Contributor_of_the_Month_Contest'>DevShare Contributor of the Month Contest</a>