Question

3
Replies
105
Views
MDAZHARUDDIN Member since 2012 13 posts
NCS
Posted: 2 years ago
Last activity: 1 year 11 months ago
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
Share this page LinkedIn