On Wednesday, January 24, 2007 6:36 PM [GMT+1=CET],
bg <[EMAIL PROTECTED]> wrote:
I've pawed through every HELP screen in Calc and can't find a way
to do this.
I have these imported CSV files - (imported into Calc, of course)
they have two fields, both with nothing but text in the cells. They
are (1) email name (2) email address. What I need to do is globally
insert, for the first column, open and close quotes, and for the
second column, open and close arrow brackets.
Graphically, here's what I have:
John Doe [EMAIL PROTECTED]
Here's the result I need:
"John Doe" <[EMAIL PROTECTED]>
Can Calc get me there? I have not yet found the means of doing so.
Thanks,
Brewster Gillett
You need to use Regular Expressions in the Find & Replace dialog.
1. Select the "name" column.
2. Open the Find & Replace dialog - Edit>Fine and Replace or the binoculars
icon in the tool bar.
3. In the dialog, click More Options
4. Select "Current selection only" *and* "Regular Expressions".
5. In the Search for box, enter (.*). That's 4 characters: open parenthesis,
dot, asterisk, close parenthesis.
6. In the Replace with box enter "&". That's 3 characters: double quote,
ampersand, double quote.
7. Click Replace All.
Now select the "address" column
Repeat the above steps 2-7 *but* in step 6 enter in the Replace with box
<&>. That's 3 characters: less than, ampersand, more than.
Done.
You might want to backup your spreadsheet before you do this, just in case
;-)
Read up about Regular Expressions in the Help or other online documentation
to learn what is happening. They are extremely useful.
Harold Fuchs
London, England
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
