• Post Reply Bookmark Topic Watch Topic
  • New Topic

Parsing a .csv file containing special characters

 
prash nagpure
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please can somebody tell me a way to parse a .csv file.
I am having an excel file(saved as a .csv file) with 8 columns and every column is having certain data.
I have written a code which parses this data and reads into a business object .
My problem is that whenever there is a text message which has the pattern like ", that is a double quote followed by a comma the code fails as my parsing mechanism recognizes this as the end of a token.I am using streamtokenizer class.
How can I take care of this..
Can somebody throw light on this issue.
Pl. rush your solution as it is urgent.Thanx in advance

 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!