katelynnm 1 Posted November 18, 2013 Report Share Posted November 18, 2013 (edited) 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 Quote Link to post Share on other sites
Steve 30 Posted November 18, 2013 Report Share Posted November 18, 2013 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") Quote Link to post Share on other sites
katelynnm 1 Posted November 18, 2013 Author Report Share Posted November 18, 2013 Thanks, Steve! I ended up using this regex: set table cell(&googleresults, #count, 1, $replace regular expression($table cell(&googleresults, #count, 1), "results(.*)", $nothing)) Quote Link to post Share on other sites
Steve 30 Posted November 19, 2013 Report Share Posted November 19, 2013 no prob Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.