Question

3
Replies
132
Views
Close popover
Mohammed Azharuddin Siddavatam (MDAZHARUDDIN)
NCS

NCS
SG
MDAZHARUDDIN Member since 2012 14 posts
NCS
Posted: December 27, 2017
Last activity: October 12, 2018
Closed
Solved

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.

Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.