Hi All,
I am learning how to parse a flatfile in webMethods. While working with CSV flatfile, I do not understand how to parse a flatfile with comma in the fields. I have parsed a flatfile without comma in the fields and is working. Kindly help me where to make the necessary configurations.

Regards
Veena

Did you review the 9-8_Flat_File_Schema_Developers_Guide.pdf

There are many topics and tutorials available on tech community. You can refer them.

If you still have issues share your CSV file and I will post the code sample at my convenient time.

AA,Singh,Aa, Singhal,Test
AA,Singh,Aa1, Singhal,Test1

Here I want to take Aa Singhal in one field, excel sheet display correctly but not able to parse using webMethods Schema, Any insight

Thank you for the response. So there is no direct way of handling this issue? Do I have to handle this through code?

Attach your CSV lets see what can be done.

Thank you Mahesh. It worked for me . I used release character.

NP

I have a new question here. I am working on variable length flat file. I am getting

“Variable Length file format invalid, file ended before record filled” exception.

My file looks like this :
NULL 12345,Rakesh,12-08-2013,BLR,GCS
NULL%1235,Raghavendra,12-08-2013,BLR,GCS
is there anything wrong is this?