Simple Delete Question

General discussions about Advanced Find and Replace
Post Reply
isofilm
Posts: 2
Joined: Mon Mar 12, 2007 11:21 pm

Simple Delete Question

Post by isofilm »

I'm sure this is simple for everyone else... but how can I delete everything after a certain character, such as a double quote, on each line.
Such as starting with:
http://www.novelconceptsinc.com/gallery ... ders-9.gif" >f-heat-spreaders-9.gif</a>
http://www.novelconceptsinc.com/gallery ... inum-1.gif" >f-heat-spreaders-aluminum-1.gif</a>
http://www.novelconceptsinc.com/gallery ... pper-1.gif" >f-heat-spreaders-copper-1.gif</a>
And ending with:
http://www.novelconceptsinc.com/gallery ... ders-9.gif
http://www.novelconceptsinc.com/gallery ... inum-1.gif
http://www.novelconceptsinc.com/gallery ... pper-1.gif
Thanks,
DT

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Post by Abacre »

Go to Batch replace tab, check on "Use regular expressions".
Put into the grid, search for:
(http://www.novelconceptsinc.com/gallery/.*)" >.*\.gif</a>

Replace with:
$1

That's all I verified it works perfectly.
Last edited by Abacre on Tue Mar 13, 2007 8:49 pm, edited 1 time in total.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

isofilm
Posts: 2
Joined: Mon Mar 12, 2007 11:21 pm

Post by isofilm »

Thanks Roman, it works perfectly.

kevinkaley
Posts: 1
Joined: Tue Sep 18, 2007 8:42 pm

Re: Simple Delete Question

Post by kevinkaley »

What if the "kept" info is different?

Example:

sprad8@hotmail.com SMTP
bnkimo@aol.com SMTP Barbara Martin-Perkins (bnkimo@aol.com)
bgreemberg@aol.com SMTP Rebecca Greemberg (bgreemberg@aol.com)
ekj8944@aol.com SMTP Beth Johnson (ekj8944@aol.com)
Joe@JoeLatorre.com SMTP

Want to keep the email address, but delete the SMTP and everything after it?

Very cool tool btw.

Abacre
Site Admin
Posts: 1223
Joined: Mon Jan 31, 2005 5:32 pm

Re: Simple Delete Question

Post by Abacre »

Kevin,

Go to Batch replace tab, check on "Use regular expressions".
Put into the grid, search for:
\sSMTP.*\r\n

Replace with:
should be empty.

That's all I verified it works perfectly.
Kind regards,
Abacre Limited
http://www.abacre.com
support@abacre.com

Post Reply