How can I export Notes field from Contact records in one field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On exporting contact records with Notes, I find that the export creates a
separate cell for every line in the Notes field instead of one cell for the
entire Notes field. Is there any way to keep all of the Notes data together
in one field? This is a biggy for me.

Any advice is very welcome! Thanks.
 
Version of Outlook? Version of Excel? (assume you're referring to Excel
since you used the term "cell").

Not a behaviour we've ever seen using Outlook. Actually just tried this
again before responding just to be sure and multi-line note fields were
exported to a single column using CSV, XLS and .MDB as output formats using
O'2003's export wizard. Ran this test using both hard and soft returns in
the Notes field. Outlook's import/export wizard has remained pretty much the
same between O'2000-O'2003 (if not actually remaining absolutely identical).

What program are you using to read the resulting data file - an MS product
or some other program? Not all programs are "multi-line" aware but that
would typically result in multiple lines per contact versus multiple
"cells".

Karl

--
_____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Yes, Outlook, Excel 2003 (sorry). I think you solved the problem. I am
importing it into ACT! which requires a .txt file. However, if I export it
as a csv file instead of a txt file, it works fine.

There is one other issue you might have a solution for. Is there a way to
strip out the carriage return symbol (I think that's what it is) before
saving it as a txt file? I don't really want to import it with that in it
but I don't know how to replace it with a space. Is there a way?

Thank you very much for your advice. You hit on the problem. Now I just
need a way to replace the funky symbol.

Deb
 
Been far too long since I've looked at the Act data structures to remember
what is imported or exported in terms of street address line fields.

Yes it is the CR (Hex value "0D" / decimal value 13 to be exact) that shows
up as the special char. For a CSV (or any text) file - you'd need a text
editor that has Hex search & replace capabilities but you'd want to make
sure that you only do it for the specific column - not exactly a
straightforward approach in most cases.

Have seen a number of Excel Add-ins that provide enhanced Find & Replace
capabilities but not familiar with any of them directly or if selective
special characters were supported. Perhaps someone else in the Excel
newsgroup can be of more help to you in that regard or alternatively search
Google for one of those Excel addins. (Reason for Excel would be to strip
the character in a specific column only and then saving it as a CSV file for
use in Act)

Karl
--
_____________________________________________________________
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2003"
http://www.contactgenie.com
 
Back
Top