"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.
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.