I have a csv file in the below format. H,"TestItems_20100107.csv",07/01/2010,20:00:00,"TT1198","MOBb","AMD",NEW,,
I require the split command to ignore the commas inside the double quotes . So i used the below split command from an earlier post. Pasted the URL that i took this command String items = line.split(",(?=([^\"]\"[^\"]\")[^\"]$)"); System.out.println("items.length"+items.length);
When i run for this CSV data I am getting the items.length printed as 8. The last two commas at the end of line after "NEW" are ignored. I want the split command to pick up these commas and return me the length as 10. It's not picking up the null commas if it's in end but it's picking it up if it's in the middle of string. Not sure what i need to modify in the split command to resolve this issue. Also in the csv file Double quotes within the contents of a Text field can be repeated (e.g. "This account is a ""large"" one")
arav vara wrote:Thanks a lot. How do i give points and accept the answer in this forum?
This topic has already been marked as resolved. If it had not, then you can request that it be marked as such, by clicking the big resolve button near the other buttons. And a moderator will review and mark accordingly.