import out look contacts csv

  • Thread starter Thread starter WebBuilder451
  • Start date Start date
W

WebBuilder451

I'm attempting to read and parse exported outlook contacts using asp.net and
i notice excel has no problem figuring out columns and fields, but i'm having
trouble with extra CR/LF in fields. Does anyone know how excel figures this
out? Is there an extra char that signifies end of line? or is it parsing csv
files in a unique way?
any help here would be greatly appreciated
 
Excel needs help parsing CR/LF in imported data.

Best to change the *.csv to *.txt then use the Text Import Wizard.

To split at a linefeed use Alt + 0100 or CTRL + j as the de-limiter.


Gord Dibben MS Excel MVP
 
Typo alert:
Alt-0010 (not 0100).

To the OP:

I've never seen this work in your situation. The CR/LF is a newline set of
characters. So excel will see what follows that crlf as a new line.

I think I'd go back to the program that creates the text file and have those
internal crlf's changed to a unique (unused) character (like the vertical bar
|).
 
Well, the thing is Excel is importing it just fine. I would just like to know
how it's doing it. There are CF/LF's in some of the fields, but excel is
figuring out how to work around them. I just wish i could!

That's what i hope to find here: Does anyone know how excel does it? This is
an exported outlook address book
--
(i''ll be asking a lot of these, but I find C# totally way cooler than vb
and there''s no go''n back!!!)
thanks (as always)

kes
 
Back
Top