Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Comma inside double Quotes, Flat File WIzard

252 views
Skip to first unread message

JayBiz

unread,
Apr 23, 2007, 3:38:02 PM4/23/07
to
Hi,
I am trying to generate schema using flat file wizard for the
following data

"1234","ABCD","123 hidden st, Apt 23","TN"
"234","BCD","123 hidden st, Apt 34","TN"
"234","BCD","123 hidden st, Apt 34","TN"
"234","BCD","123 hidden st, Apt 34","TN"

As you see from the above lines Comma(,) is the delimiter but problem is
there will be a comma (,) inside one of the columns (like address).

Please let me know how I can generate a schema for this type file.

thanks in adavance.


JayBiz

unread,
Apr 23, 2007, 4:08:04 PM4/23/07
to
I found it.
Just incase if any body is trying same thing:

for all the nodes that have double quotes(in my case all the child nodes),
select that node in the schema and in the properties change the Wrap
Character type to " character"

and also enter " in the wrap character property this will solve the problem.

0 new messages