Parsing CSV file

Hi,I am trying to parse CSV file using COM/DCOM e*Way , i am successfull with excel workbook, I am not sure about proceeding for CSV file.Any help would be appreciated.Thanks in advance.Srini

[226 byte] By [Yalavarthia] at [2007-11-27 8:11:16]

«« Problem with modify a field of an applet from other applet
»» what is a DAO and how to implement a sample example?

# 1

If you know the structure of the CSV file, then why not create a user defined OTD with comma as field delimiter and new line as record delimiter & unmarshal the payload using BatchLocal eway.

spoosarlaa at 2007-7-12 19:55:10 >

top of Java-index,Java Enterprise System,Java Composite Application Platform Suite -- General Discussion...

# 2

Thank you so much for your reply , but i have requirement as below.

The structure of the file is

feild1,filed2,filed3,filed4.

so, I created a OTD with comma delimted on each filed.But I have input data as below :

100,aaa,bbb,ccc

200,aaa,bbb,"ccc,ddd"

300,"aaa,xxx",bbb,"ccc,ddd".

Data within the quotes is causing problems for me.

Yalavarthia at 2007-7-12 19:55:10 >

# 3

What kind of problems is it causing? Any errors on parsing? Are you able to parse it to 4 different fields?Cheers,SP

spoosarlaa at 2007-7-12 19:55:10 >

Java Enterprise System

Java Composite Application Platform Suite -- General Discussion

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

Parsing CSV file

Java Enterprise System Hot Topic

Java Enterprise System

All Classified