find and replace links in a large text file - GoFuckYourself.com

d-null · 06-23-2009, 03:34 PM

is there a utility, or is it possible with notepad++ or any other of the popular code editors to do a search and replace with wildcards?

eg. say you have a large text file, that is scattered with a bunch of <a href... type of links, but they are all different as far as text and url's, I would like to use a * wildcard to be able to search for all occurences of any type of link and replace it with something else

any ideas?

woj · 06-23-2009, 03:35 PM

regexp FTW

d-null · 06-23-2009, 03:44 PM

Quote:

Originally Posted by woj

regexp FTW

ok, I'm seeing it, now just have to learn the syntax :P

fris · 06-23-2009, 06:28 PM

Code:

sed 's/old/new/g' input.txt > output.txt

d-null · 06-23-2009, 06:33 PM

Quote:

Originally Posted by fris

Code:

sed 's/old/new/g' input.txt > output.txt

interesting, I need it to do some regexp matching though, the old url's are all different, and I want to match them all with one command

GrouchyAdmin · 06-23-2009, 06:35 PM

wildcard to match any type of link? Sure!

Code:

/a[\s]+[^>]*?href[\s]?=[\s\"\']+(.*?)[\"\']+.*?>([^<]+|.*?)?<\/a>/i

Enjoy.

d-null · 06-23-2009, 06:41 PM

Quote:

Originally Posted by GrouchyAdmin

wildcard to match any type of link? Sure!

Code:

/a[\s]+[^>]*?href[\s]?=[\s\"\']+(.*?)[\"\']+.*?>([^<]+|.*?)?<\/a>/i

Enjoy.

thanks Grouchy, you saved me some time, I'll try it out soon

d-null · 06-23-2009, 06:47 PM

edit: not working for some reason, is the code right and I am doing something wrong? using regexp search but not matching

96ukssob · 06-23-2009, 06:50 PM

download textpad, it works great.

press F8, then use .*. as the wild card.

GrouchyAdmin · 06-23-2009, 06:59 PM

The above is Perl Regex, not "universal" regex.

d-null · 06-23-2009, 07:01 PM

Quote:

Originally Posted by GrouchyAdmin

The above is Perl Regex, not "universal" regex.

oh ok, I was trying to use it with notepad++ and no luck with that

GrouchyAdmin · 06-23-2009, 07:02 PM

Quote:

Originally Posted by d-null

oh ok, I was trying to use it with notepad++ and no luck with that

I just use TextPad for that kind of shit when on Windows It usually takes normal, or semi-perl regex just fine. Sorry, never used NP++.

d-null · 06-23-2009, 07:05 PM

found the answer:

Code:

<a href="[^"]+">[^<]+</a>

thanks for the help, it was interesting, maybe this thread will help someone else too

06-23-2009, 03:34 PM	#1
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	find and replace links in a large text file is there a utility, or is it possible with notepad++ or any other of the popular code editors to do a search and replace with wildcards? eg. say you have a large text file, that is scattered with a bunch of <a href... type of links, but they are all different as far as text and url's, I would like to use a * wildcard to be able to search for all occurences of any type of link and replace it with something else any ideas? __________________ __________________ Looking for a custom TUBE SCRIPT that supports massive traffic, load balancing, billing support, and h264 encoding? Hit up Konrad! Looking for designs for your websites or custom tubesite design? Hit up Zuzana Designs Check out the #1 WordPress SEO Plugin: CyberSEO Suite

06-23-2009, 03:35 PM	#2
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	regexp FTW __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

06-23-2009, 06:28 PM	#4
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,336	Code: sed 's/old/new/g' input.txt > output.txt __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

06-23-2009, 06:35 PM	#6
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	wildcard to match any type of link? Sure! Code: /a[\s]+[^>]?href[\s]?=[\s\"\']+(.?)[\"\']+.?>([^<]+\|.?)?<\/a>/i Enjoy. __________________ AIM: GrouchyGfy

06-23-2009, 06:47 PM	#8
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	edit: not working for some reason, is the code right and I am doing something wrong? using regexp search but not matching __________________ __________________ Looking for a custom TUBE SCRIPT that supports massive traffic, load balancing, billing support, and h264 encoding? Hit up Konrad! Looking for designs for your websites or custom tubesite design? Hit up Zuzana Designs Check out the #1 WordPress SEO Plugin: CyberSEO Suite

06-23-2009, 06:50 PM	#9
96ukssob So Fucking Banananananas Industry Role: Join Date: Mar 2003 Location: If I was in your ass you'd know it Posts: 12,991	download textpad, it works great. press F8, then use .*. as the wild card. __________________ Email: Clicky on Me

06-23-2009, 06:59 PM	#10
GrouchyAdmin Now choke yourself! Industry Role: Join Date: Apr 2006 Posts: 12,085	The above is Perl Regex, not "universal" regex. __________________ AIM: GrouchyGfy

06-23-2009, 07:05 PM	#13
d-null . . . Industry Role: Join Date: Apr 2007 Location: NY Posts: 13,724	found the answer: Code: <a href="[^"]+">[^<]+</a> thanks for the help, it was interesting, maybe this thread will help someone else too __________________ __________________ Looking for a custom TUBE SCRIPT that supports massive traffic, load balancing, billing support, and h264 encoding? Hit up Konrad! Looking for designs for your websites or custom tubesite design? Hit up Zuzana Designs Check out the #1 WordPress SEO Plugin: CyberSEO Suite