Win a copy of The Way of the Web Tester: A Beginner's Guide to Automating Tests this week in the Testing forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Parsing a .csv file containing special characters

prash nagpure
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