aspose file tools*
The moose likes Beginning Java and the fly likes Regarding split method Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Regarding split method" Watch "Regarding split method" New topic
Author

Regarding split method

arav vara
Greenhorn

Joined: Feb 10, 2010
Posts: 6

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);

http://stackoverflow.com/questions/1757065/java-splitting-a-comma-separated-string-but-ignoring-commas-in-quotes/1757107

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")
Henry Wong
author
Sheriff

Joined: Sep 28, 2004
Posts: 18821
    
  40


Use the overloaded split() methods instead -- the one that takes a limit. And choose a negative value as the limit.

Henry


Books: Java Threads, 3rd Edition, Jini in a Nutshell, and Java Gems (contributor)
arav vara
Greenhorn

Joined: Feb 10, 2010
Posts: 6
Thanks a lot. Will try it. Could you please post me some good websites for learning regex patterns.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38726
    
  23
Try here for regular expressions.
arav vara
Greenhorn

Joined: Feb 10, 2010
Posts: 6
Thanks a lot. How do i give points and accept the answer in this forum?
Henry Wong
author
Sheriff

Joined: Sep 28, 2004
Posts: 18821
    
  40

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.

We do not use a point system on the ranch.

Henry
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19692
    
  20

"arav vara", I suggest you read your private messages and follow the instructions in them.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Regarding split method