<div dir="ltr">I just tried this on outlook for mac 2011:<div><br></div><div>table headers:</div><div>First Name<span style="white-space:pre-wrap"> </span>Last Name<span style="white-space:pre-wrap"> </span>Title<span style="white-space:pre-wrap"> </span>Suffix<span style="white-space:pre-wrap"> </span>Nickname<span style="white-space:pre-wrap"> </span>Company<span style="white-space:pre-wrap"> </span>Job Title<span style="white-space:pre-wrap"> </span>Dept<span style="white-space:pre-wrap"> </span>Work Street Address<span style="white-space:pre-wrap"> </span>Work City<span style="white-space:pre-wrap"> </span>Work State<span style="white-space:pre-wrap"> </span>Work Zip<span style="white-space:pre-wrap"> </span>Work Country/Region<span style="white-space:pre-wrap"> </span>Work URL<span style="white-space:pre-wrap"> </span>Home Street Address<span style="white-space:pre-wrap"> </span>Home City<span style="white-space:pre-wrap"> </span>Home State<span style="white-space:pre-wrap"> </span>Home Zip<span style="white-space:pre-wrap"> </span>Home Country/Region<span style="white-space:pre-wrap"> </span>Home URL<span style="white-space:pre-wrap"> </span>Home Phone 1<span style="white-space:pre-wrap"> </span>Home Phone 2<span style="white-space:pre-wrap"> </span>Home Fax<span style="white-space:pre-wrap"> </span>Work Phone 1<span style="white-space:pre-wrap"> </span>Work Phone 2<span style="white-space:pre-wrap"> </span>Work Fax<span style="white-space:pre-wrap"> </span>Pager<span style="white-space:pre-wrap"> </span>Mobile Phone<span style="white-space:pre-wrap"> </span>Main Phone<span style="white-space:pre-wrap"> </span>Assistant Phone<span style="white-space:pre-wrap"> </span>Custom Phone 1<span style="white-space:pre-wrap"> </span>Custom Phone 2<span style="white-space:pre-wrap"> </span>Custom Phone 3<span style="white-space:pre-wrap"> </span>Custom Phone 4<span style="white-space:pre-wrap"> </span>Email Address 1<span style="white-space:pre-wrap"> </span>Email Address 2<span style="white-space:pre-wrap"> </span>Email Address 3<span style="white-space:pre-wrap"> </span>Email Address 4<span style="white-space:pre-wrap"> </span>Email Address 5<span style="white-space:pre-wrap"> </span>Email Address 6<span style="white-space:pre-wrap"> </span>Email Address 7<span style="white-space:pre-wrap"> </span>Email Address 8<span style="white-space:pre-wrap"> </span>Email Address 9<span style="white-space:pre-wrap"> </span>Email Address 10<span style="white-space:pre-wrap"> </span>Email Address 11<span style="white-space:pre-wrap"> </span>Email Address 12<span style="white-space:pre-wrap"> </span>Email Address 13<span style="white-space:pre-wrap"> </span>Instant Messaging 1<span style="white-space:pre-wrap"> </span>Instant Messaging 2<span style="white-space:pre-wrap"> </span>Instant Messaging 3<span style="white-space:pre-wrap"> </span>Instant Messaging 4<span style="white-space:pre-wrap"> </span>Instant Messaging 5<span style="white-space:pre-wrap"> </span>Instant Messaging 6<span style="white-space:pre-wrap"> </span>Instant Messaging 7<span style="white-space:pre-wrap"> </span>Instant Messaging 8<span style="white-space:pre-wrap"> </span>Instant Messaging 9<span style="white-space:pre-wrap"> </span>Instant Messaging 10<span style="white-space:pre-wrap"> </span>Instant Messaging 11<span style="white-space:pre-wrap"> </span>Instant Messaging 12<span style="white-space:pre-wrap"> </span>Instant Messaging 13<span style="white-space:pre-wrap"> </span>Custom 1<span style="white-space:pre-wrap"> </span>Custom 2<span style="white-space:pre-wrap"> </span>Custom 3<span style="white-space:pre-wrap"> </span>Custom 4<span style="white-space:pre-wrap"> </span>Custom 5<span style="white-space:pre-wrap"> </span>Custom 6<span style="white-space:pre-wrap"> </span>Custom 7<span style="white-space:pre-wrap"> </span>Custom 8<span style="white-space:pre-wrap"> </span>Custom date 1<span style="white-space:pre-wrap"> </span>Custom date 2<span style="white-space:pre-wrap"> </span>Spouse<span style="white-space:pre-wrap"> </span>Birthday<span style="white-space:pre-wrap"> </span>Anniversary<span style="white-space:pre-wrap"> </span>Notes<span style="white-space:pre-wrap"> </span>Age<span style="white-space:pre-wrap"> </span>Astrology sign<span style="white-space:pre-wrap"> </span>Bloodtype<span style="white-space:pre-wrap"> </span>Furigana Company Name<span style="white-space:pre-wrap"> </span>Furigana First Name<span style="white-space:pre-wrap"> </span>Furigana Last Name<span style="white-space:pre-wrap"> </span>Furigana Spouse Name<span style="white-space:pre-wrap"> </span>Interests<span style="white-space:pre-wrap"> </span>Furigana Home Address line 2<span style="white-space:pre-wrap"> </span>Furigana Home Postal Code<span style="white-space:pre-wrap"> </span>Name<span style="white-space:pre-wrap"> </span>Category<br>
</div><div><br></div><div>tab separated</div><div><br></div><div><div>Documents/Contacts Export.txt: ASCII text, with very long lines, with CR line terminators</div></div><div><br></div><div>(some of the column titles are outstanding!)</div>
</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, Feb 6, 2013 at 12:27 PM, Andrew Stewart <span dir="ltr"><<a href="mailto:boss@airbladesoftware.com" target="_blank">boss@airbladesoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><br>
On 6 Feb 2013, at 13:16, Andrew Premdas wrote:<br>
> Have you looked at fastercsv (<a href="https://rubygems.org/gems/fastercsv" target="_blank">https://rubygems.org/gems/fastercsv</a>)<br>
<br>
</div>Thanks, though I need to know the column separator and the file encoding – not how to read CSV generally.<br>
<br>
For example one random source I found said the Outlook's CSV files were comma separated and ASCII-8BIT; another said they were tab separated and UTF-16LE.<br>
<br>
Cheers,<br>
<div><div>Andy<br>
_______________________________________________<br>
Chat mailing list<br>
<a href="mailto:Chat@lists.lrug.org" target="_blank">Chat@lists.lrug.org</a><br>
<a href="http://lists.lrug.org/listinfo.cgi/chat-lrug.org" target="_blank">http://lists.lrug.org/listinfo.cgi/chat-lrug.org</a><br>
</div></div></blockquote></div><br></div>