Hi Peter,
The most straightforward way to do what you want is to open the csv file
and import all of it. Fill an empty column with the formula
=IF(AND(ISERROR(FIND("msn.com";A1));ISERROR(FIND("hotmail.com";A1)));"NOT";"Flag")
This is assuming that the addresses are in column A. Adjust the formula
if they're not. If you paste the formula above into the top cell of your
empty column, then fill down, you'll have 'Flag' or 'NOT' in each cell.
Sort the entire sheet by that column and delete the rows that you don't
want.
tc
Peter Abbott wrote:
Brian Barker keyed the following on 7/12/2007 11:56 PM:
At 23:21 12/07/2007 -0400, Peter Abbott wrote:
I have a file of email addresses, one per line.
I thought that if I changed the file type to CSV and open it with
scalc, I could somehow filter out the ones with hotmail.com and
msn.com, but I haven't been able to configure the filter to do this.
Can anyone help? Thanks.
Is the original file a text document in Writer?
No. It's a plain text file.
It is probably easiest to make the changes there.
Actually, the easiest is to use the MSDOS command findstr, but I wanted
to use scalc's filters. :-)
Were the original lines separated by pressing Enter - in other words,
are they actually separate paragraphs in Writer terms? I assume so.
And by "filter out" you mean you want them deleted?
No. I want them separated from the rest of the file. What I'm trying to
do is create a file that contains only lines/rows that contain either
msn.com or hotmail.com on them.
I trust this helps.
I appreciate your effort, Brian.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
