22,000 comments

mrgrim · Sep 13, 2011

Ok so I have 66,000 comments but I'm trying to clean them, I even tried importing um as HTML file in a browser, but it came out as one line.. They have HTML tags mixed with some markup for styling.. Also there's some numbers mixed into the front of some of the lines(12.) 13.) 14.) etc)along with some quotes. Find and replace wont cut it for this any ideas?

Edit: 66,000 not 22,000

Nitros · Sep 13, 2011

few simple lines in php script should do the work

accelerator_dd · Sep 13, 2011

You can use notepad++ and regex.

Here is a cheatset for regex http://www.addedbytes.com/download/regular-expressions-cheat-sheet-v1/png/

to remove first two numbers in each line use

^[0-9]?

But be sure when using Find & Replace in the lower left corner to select regex

mrgrim · Sep 13, 2011

accelerator_dd said:
You can use notepad++ and regex.

Here is a cheatset for regex http://www.addedbytes.com/download/regular-expressions-cheat-sheet-v1/png/

to remove first two numbers in each line use

^[0-9]?

But be sure when using Find & Replace in the lower left corner to select regex

Awesome!

The numers are like
"13.) this comment is the comment of the year, ducks swim Seagull eat baygulls!"
"14.) {strong} your ass is grass {strong/}.."

The numbers and tags are what I'm trying to scrub!

Thanks guys I'll try note pad ++ I use it for other stuff..

mrgrim · Sep 13, 2011

Nitros said:
few simple lines in php script should do the work

For HTML, not for number bullets...

accelerator_dd · Sep 13, 2011

mrgrim said:
Awesome!

The numers are like
"13.) this comment is the comment of the year, ducks swim Seagull eat baygulls!"
"14.) {strong} your ass is grass {strong/}.."

The numbers and tags are what I'm trying to scrub!

Thanks guys I'll try note pad ++ I use it for other stuff..

To remove the .) as well, you can modify the regex like this:

^[0-9]?.)

Or when the first regex done, just do a simple find & replace and find ".)" and replace with nothing

VIC SEO · Sep 19, 2011

You can use a scipt in PHP or notepad++ to get the desired result. I understand how it must look like and hope your problem gets solved using this method.

22,000 comments

mrgrim

Junior Member

Nitros

Power Member

accelerator_dd

Elite Member

mrgrim

Junior Member

mrgrim

Junior Member

accelerator_dd

Elite Member

VIC SEO

BANNED

Main Menu

Marketplace

Making Money

BlackHat World