pbohman Posted June 20, 2017 Share Posted June 20, 2017 Hi All,I am trying to export a csv file from JasperSoft Studio in Eclipse, the problem is that each row has a different number of columns.The first row has two columns. and the next two has twelvei have pasted below part of the CSV file I am generating, my issue lies with the commas that i have pointed out in red below.If anyone can help me figure out where in my java code or where in the xml code that I can limit the delimiters for the first row let me know.Any input at all would help. textInTitle , TextInTitle ,,,,,,SometextInColumn,,,moretext,text,text,text,texttextInDetails,,,0.0%,100.0%,0.0%,21.5%,3.28%textInDetails,,,100.0%,0.0%,0.0%,16.97%,3.28% Thanks,Patrick Link to comment Share on other sites More sharing options...
hozawa Posted June 20, 2017 Share Posted June 20, 2017 That's the csv specs. If you want to delete those commas, you can just use "sed" command from bash shell to delete them. Link to comment Share on other sites More sharing options...
pbohman Posted June 21, 2017 Author Share Posted June 21, 2017 Figured It out thanks Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now