Parsing CSV Flatfile with comma in the fields

Mahathi_Vaduguru · October 15, 2015, 6:57pm

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

Mahesh_K_Sreenivas · October 15, 2015, 9:45pm

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.

Mahathi_Vaduguru · October 15, 2015, 9:58pm

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

Mahesh_K_Sreenivas · October 16, 2015, 9:56am

Attach your CSV lets see what can be done.

Mahathi_Vaduguru · October 16, 2015, 4:18pm

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

Mahesh_K_Sreenivas · October 16, 2015, 4:21pm

NP

Mahathi_Vaduguru · October 16, 2015, 9:48pm

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?