The BizTalk Editor help file said the wrap character can solve this just
like you use escape character.
I wonder why it's not working in my case. I attached my file in last
Here is what they say in the help file:
Wrap Character Type a character to enclose field data. This property
is useful if you have a character in your field data that is also used as
the delimiter value for the field's parent node. For example, if your field
and you have chosen a comma as the delimiter value of the node that
contains the field, BizTalk Editor interprets the comma after "Browne" to be
a delimiter, even if you intend for it to be part of the field data. A
solution for this is to define a value for the wrap character property and
then enclose the field data in the wrap character. For example, you can set
the wrap character property to double quotation marks for the first field
and then type your field data as in the following example:
The comma between the double quotation marks is interpreted by BizTalk
Editor to be field data rather than a delimiter value
> Hi Yang,
> I tried pue escape character '/', it works.
> But the flatfile is what we get from our customer. Their generate the
> I attached the file to you, without set the escape character. Did you
> they use double quote to the field text. I set the double quote as wrap
> character. I don't know If I can do something with this double quote to
> BizTalk treat the whole field text as a string.
> Thanks again.
> > If you must use comma in the input txt file, you can use another field
> > delimiter. That'd be a easy
> > workaround. Or, you can define an escape character.
> > HTH
> > Everett Yang