[solved] Selecting and Removing Part of a String

[katelynnm 1]

I have a list of keywords and results.  I want to delete everything in the second column from the word "results" onward.  I can't seem to figure out how to select that portion of the strings since they are not always exactly the same.  Is there some sort of wildcard I can do or anything?

Any help would be greatly appreciated!

 

For reference, here's a screencap of the table:

 

http://i42.tinypic.com/10e36ma.jpg

Edited November 18, 2013 by katelynnm

[Steve 30]

Hi Katelynnm,

 

Try using regex to find only the part you are looking for.  This should point you in the right direction:

set(#results, "4380 results (0.17 seconds)", "Global")
set(#new results, $find regular expression(#results, ".+(?=\\ results)"), "Global")

[katelynnm 1]

Thanks, Steve!   I ended up using this regex:

 

set table cell(&googleresults, #count, 1, $replace regular expression($table cell(&googleresults, #count, 1), "results(.*)", $nothing))

[Steve 30]

no prob