Hi,
I have a problem with a CSV-file I have to read (actually I have to convert
it to a XML).
In some 'fields' of the CSV-file are some line-feed characters included (\r
??? don't know because I cannot capture them) (I suppose it are not carriage
returns). The problem is now that the StreamReader.ReadLine is considering
them too as an end-of-line, and not only the real carriage return.
As a result I am getting records that are incomplete and that is storing the
wrong data in the wrong fields on the next line when splitting the line on
the separator.
When I import the data in Access, I have the same problem, except when I set
the Text Qualifier to " (double quotes). Is there a similar thing I can do
with the StreamReader???
Any help will be appreciated very much.
Kind regards,
Christian