Question

2
Replies
23
Views
Liam Ceaplen (LiamC)
SSE plc

SSE plc
GB
LiamC Member since 2019 3 posts
SSE plc
Posted: 2 weeks 5 days ago
Last activity: 2 weeks 5 days ago
Posted: 24 May 2021 14:46 EDT
Last activity: 25 May 2021 12:02 EDT
Solved

CSV Parsing issue with double quotes

Hello, 

 

I have an issue where we are receiving a CSV formatted file with "" around each field. 

Issue is the parse fails on the last field if it is empty if the final field is populated on all lines it will process entire file otherwise it will fail the entire file. 

See below; 

"test","test2",""

"test","test2","test3"

"test","test2",""

Pega Platform 8.2.8 Data Integration Communications and Media Lead System Architect