Overture Keyword Mining Shortcut

Remove the numbers quickly

[werty]

If you have a text editor that supports regular expressions copy the list, numbers included, from the overture suggestion tool, and paste them into your text editor.

Do a find and replace with regular expressions checked on

Find:
\s\d{1,10}\s\s

Replace:

It will strip all the search numbers from the list and let you paste it right into adwords or excel.

[eWhisper]

Great tip.

Know of any excel plugins that allow regular expression or have a text editor you suggest for this?

[edited by: eWhisper at 4:55 pm (utc) on July 12, 2005]

[mona]

Nice suggestion, werty! I just tried it out and it works like a charm. BTW, if you have no idea where to find this text editor (which I didn't;-), do a search for JEdit. It's free and there's a Mac OS version, too.

[sun818]

There are many free command line tools for DOS/Windows (ported from Unix) that can process text files using regular expressions.

[werty]

I use editpad pro, but I hear dreamweaver, homesite, and ultraedit all support this as well.

[ivanw]

My favorite tool is regexbuddy, which also teaches you how to construct the correct regexes.

Ivan

[Nefig]

Very interesting!
Although I ofthen get html source, paste it in DW which is open 95% of the time, select column with words and paste it anywhere I want, let's say, Excel, or notepad - - to remova formatting - and then Excel. Quick and easy; It's just quick general way to get any column-formatted information for me.

[Tapolyai]

Excel methodology -

Microsoft Internet Explorer Version
Go to Overture mining tool.

Highlight the numbers and words.
Control-C (or right click, copy)
Switch to Excel
Select A1 cell
Paste Special... (under Edit Text Menu)
Select "Unicode Text"
Click Ok.
Select cell B1.
Enter following equation exactly:
=TRIM(RIGHT(A1,LEN(A1)-FIND(" ",TRIM(A1),1)))
(note the single space between the double quotes!)
Hit enter.
Hover over lower right corner of cell B1 (cursor will switch to solid black cross hair).
Double click corner of B1 cell.
This should autopopulate all lines till the last keyword.
Select column B (by clicking on the column header).
Press Control-C or right click and select copy.
Switch to Browser.
Go to Google Adsense and paste.

Done.

Firefox Version
Go to Overture mining tool.

Highlight the numbers and words.
Control-C (or right click, copy)
Switch to Excel
Select A1 cell
Paste Special... (under Edit Text Menu)
Select "Unicode Text"
Click Ok.
Select cell C1.
Enter following equations exactly:
=TRIM(B1)
Hit enter.
Hover over lower right corner of cell C1 (cursor will switch to solid black cross hair).
Double click corner of B1 cell.
This should autopopulate all lines till the last keyword.
Select column C (by clicking on the column header).
Press Control-C or right click and select copy.
Switch to Browser.
Go to Google Adsense and paste.

Done.
- - - -
Firefox actually transfers the data numbers and text into separate columns so that is where the reduced work comes from.

[ivanw]

I thought I'd share that we have released a Free tool that does exactly this, and also allows you to manage your keyword lists.

Google on "thedowser free keyword tool".

cheers,
Ivan Wong