Question
DXC
SG
Last activity: 12 Oct 2018 1:11 EDT
CSV Parsing Issue
Hi Team,
We have a requirement as below.
As part of interface we will be receiving comma seperated values with .txt extension file which needs to be parsed and case should be updated. The delimiter we are using is comma(,).
H,7100063342,30112017,30112017,DELTA ENGINEERING CORPORATION,BC,10,123.12,1670.21,1671.21,CAAS/PM/2017/0160,CAAS/APP/YYYY/####
But in the text fields, it can contain Comma(,) as below and such fields will be indicated in Quotes"".
Hi Team,
We have a requirement as below.
As part of interface we will be receiving comma seperated values with .txt extension file which needs to be parsed and case should be updated. The delimiter we are using is comma(,).
H,7100063342,30112017,30112017,DELTA ENGINEERING CORPORATION,BC,10,123.12,1670.21,1671.21,CAAS/PM/2017/0160,CAAS/APP/YYYY/####
But in the text fields, it can contain Comma(,) as below and such fields will be indicated in Quotes"".
H,7100063342,30112017,30112017,"DELTA, ENGINEERING CORPORATION","BAA,CAC",10,123.12,1670.21,1671.21,CAAS/PM/2017/0160,CAAS/APP/YYYY/####
So we need to prase them as one field.(DELTA, ENGINEERING CORPORATION)(BAA,CAC).
Is there any possibility using service file by which we can achieve this.
Accepted Solution
DXC
SG
Issue has been identified, from Source system we are getting some unknown characters(attached). Our row type identifier was H but in the file few unknown characters have been added because of which parsing is not being started. Identified this using HXD software.
JPMorgan Chase & Company
US
Hi,
Please check the encoding format which you are using, also test in parser rule by providing sample data.
I am not observing this in my instance. please find attachment.
Accepted Solution
DXC
SG
Issue has been identified, from Source system we are getting some unknown characters(attached). Our row type identifier was H but in the file few unknown characters have been added because of which parsing is not being started. Identified this using HXD software.
