Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
CSV Emitter issue when opening with notepad
magic_bern
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>