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]