Convert Outlook Mac list to .CSV

2013-06-03 Thread Diane Ross
Outlook Mac 2011 groups can only be saved as a list separated by semicolon. Names are not saved. jane...@icloud.com; john...@icloud.com; bigb...@me.com; I want to convert this list as tab delimited so I can convert to .csv in Excel. When I replace the ; with ,\r I get an extra character at

Re: Convert Outlook Mac list to .CSV

2013-06-03 Thread Jeremy Cowgar
Possibly search for ;space .. ; That may not get the last occurrence, but should get the vast majority. Jeremy On Jun 3, 2013, at 2:50 PM, Diane Ross dianeofore...@live.com wrote: Outlook Mac 2011 groups can only be saved as a list separated by semicolon. Names are not saved.

Re: Convert Outlook Mac list to .CSV

2013-06-03 Thread Jeremy Cowgar
Oh, you can also use a regular expression if you wish to get fancy... ;\s* should do it. \s = whitespace (space, tab, newline) and * means zero or more occurrences. Be sure to enable Grep by ticking the checkbox. Jeremy On Jun 3, 2013, at 3:17 PM, Jeremy Cowgar jer...@cowgar.com wrote:

Re: Convert Outlook Mac list to .CSV

2013-06-03 Thread LuKreme
On 03 Jun 2013, at 12:50 , Diane Ross dianeofore...@live.com wrote: Outlook Mac 2011 groups can only be saved as a list separated by semicolon. Names are not saved. jane...@icloud.com; john...@icloud.com; bigb...@me.com; I want to convert this list as tab delimited so I can convert to

Re: Convert Outlook Mac list to .CSV

2013-06-03 Thread dianeoforegon
That worked. by adding space to find criteria, they are now sorting correctly. Thanks!! Find ; Replace ,\r On Monday, June 3, 2013 11:50:17 AM UTC-7, dianeoforegon wrote: Outlook Mac 2011 groups can only be saved as a list separated by semicolon. Names are not saved.

Re: Convert Outlook Mac list to .CSV

2013-06-03 Thread Christopher Stone
On Jun 03, 2013, at 13:50, Diane Ross dianeofore...@live.com wrote: Outlook Mac 2011 groups can only be saved as a list separated by semicolon. Names are not saved. jane...@icloud.com; john...@icloud.com; bigb...@me.com; I want to convert this list as tab delimited so I can convert to