Carriage Returns

[instauratio]

I have a csv spreadsheet with a column of Notes (as in the "notes" from an
exported Outlook contacts folder). I wish to place a carriage return between
separate items within the Notes field. I want to control where a new line
begins before I export/import the notes back into Outlook.

e.g.

office hours m-f 9-5 sat 9-noo
n call 555-1212 if you have qu
estions.


first assistant Kim Shelby-Gra
nt

Second assistant Grace Jones-s
mith

Should read

office hours
m-f 9-5 sat 9-noon
call 555-1212
if you have questions.


first assistant
Kim Shelby-Grant

Second assistant
Grace Jones-smith

Thanks

 

[Dave]

that can be done, but it may require a customized import and/or export.
most csv import routines work on a line of data at a time to parse it...
where there is an embedded carriage return it will look like a new line and
start parsing a new line of data. you either need an import that is smart
enough to handle quoted text that includes carriage returns, and an export
that quotes them like that. or a special export that will substitute some
other character or special code in the string and then an import that will
recreate the carriage returns after the csv parsing is done.