CSV to Flat File Schema in BizTalk 2016

Harish Sharma 121 Reputation points
2021-01-22T07:31:02.367+00:00

Hi,

I have used csv in past without any issues, but now I am running into csv data issue.

Now, I have csv, saved from excel and problem is the way data is being wrapped within each cells when data itself contains comma.

It would be straight forward to use Comma as Child Delimeter, when csv data looks like this
1,1001,"First Name", "Addr1", "Addr2"
2,1002,"First Name", "Addr1", "Addr2"

But the csv I have looks like this

1,1001,"First Name", "Addr1, something", "Addr2"
2,1002,"First Name", "Addr1, something else", "Addr2"

Now when I use "," as Child Delimiter, it splits Addr1 into following data field and last one is falling apart failing the instance validation.

Any idea how to handle this kind of data?
Appreciate any guidance.

Thanks,
Harish

Microsoft BizTalk Server
Microsoft BizTalk Server
A family of Microsoft server products that support large-scale implementation management of enterprise application integration processes.
349 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,902 questions
0 comments No comments
{count} votes

Accepted answer
  1. Harish Sharma 121 Reputation points
    2021-01-22T15:00:36.803+00:00

    My bad, completely forgot to use WRAP character.
    Just in case if somebody else needs an answer.
    First, you can set default WRAP Character as double quote (") at Schema level and select WRAP Character Type as (default WRAP Character) at Element Level.
    Or second, you can set directly at Element level by selecting WRAP Character Type as (Character) and WRAP Character as double quote (").

    Thanks,
    Harish

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful