Exporting Hotmail Contacts - OpenOffice Calc

[C M Reinehr]

On Thursday 29 March 2007 10:46, Tim Wunder wrote:
> On Thursday 29 March 2007 11:24:38 am C M Reinehr wrote:
> > James,
> >
> > On Wednesday 28 March 2007 19:00, James McDonald wrote:
> > > I was trying to export my wifes free hotmail account contacts out.
> > >
> > > They are clever I will give them that. There is no facility to export
> > > the contacts to csv etc. The hotmail display of contacts does a semi
> > > random obsfucation (replacing some of the last few characters in the
> > > email address with `...') to stop you simply copying them off the web
> > > page.
> > >
> > > I had to copy the lot into oocalc and then manually complete each email
> > > address.
> > >
> > > I noticed oocalc doesn't have a native text to column feature (oowriter
> > > does). I always use this feature in excel so I had to download and
> > > install a plugin from the OpenOffice Macro Add-in site
> > > http://www.ooomacros.org/user.php which is quite handy for adding
> > > functionality that isn't in the core distribution.
> >
> > 	I'm not sure we're talking about the same thing, but if you want to open
> > a text file in OO.org Calc with the intention of organizing the text into
> > columns you just need to select a File Type of "Text CSV" from the file
> > open window. After selecting the file a second window will open allowing
> > you to specify fixed width or variable, separated by tab, comma, etc.
> >
> > cmr
>
> What he's talking about is the ability to convert text to columns within
> the spreadsheet. I use that feature all the time in Excel. It's different
> from opening a file as txt/csv because opening the file creates a new file.
> I have many spreadsheets where I paste columnar data into an existing
> spreadsheet and then use Excel's built-in Data-Text to Columns utility.
> I've used the referenced OOo plugin, and while it essentially does what it
> says, it pales in comparison to the native utility in Excel (sadly).
>
> Tim

Tim,

Thanks! I've never used Excel and didn't know that. It sounds like there are 
several ways to work around this, but none as quick & easy.

cmr
-- 
Debian 'Etch' - Registered Linux User #241964
--------
"More laws, less justice." -- Marcus Tullius Ciceroca, 42 BC