Read a CSV file

[tinu_n]

Hi All,

Can you please help with the FCC parameters to read the below CSV format file?

AAA,BBB,"1111,2222,3333"

No of fields : A,B,C

I gave the below parameter, but PI is considering this single field "1111,2222,3333" as three fields,

Record.fieldSeparator   ,

Record.endSeparator   'nl'

Record.fieldNames   

Can you please let me know how to consider this field "1111,2222,3333" as single field?

Thanks,

Tinu

[bhavesh_kantilal · Accepted solution]

Use the parameter

Record.enclosureSign with value -> "

Regards

Bhavesh

[tinu_n · Accepted solution]

Hi Bhavesh,

Thanks a lot, this worked.

Thanks,

Tinu

[former_member186851 · Accepted solution]

Thats cool Bhavesh.

I was using the below parameter to acheive the same req.

[former_member186851]

Hello Tinu,

Try like this

Record.fieldSeparator  'nl'

It should work