Posted: 27 Dec 2017 20:44 EST 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"". 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.
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.