question

HarishSharma-2149 avatar image
0 Votes"
HarishSharma-2149 asked EmmanuelAbramProfeta-4848 edited

CSV to Flat File Schema in BizTalk 2016

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

azure-logic-appsbiztalk-server
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

HarishSharma-2149 avatar image
1 Vote"
HarishSharma-2149 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.