Yes indeed Skip, regex is the way to go :-) matchText(theColumn,"^(.*?)\s*$",tOutput) should put the text minus trailing spaces into the tOutput variable.
Pete lcSQL Software <http://www.lcsql.com> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html> On Mon, Jul 14, 2014 at 1:56 PM, Magicgate Software - Skip Kimpel < [email protected]> wrote: > Good afternoon, > > I have a datagrid and column 1 has trailing spaces in the data items that I > need to get rid of. The number of trailing spaces is never > consistent. Once again, I think regex will be my friend / worst enemy :) > > Suggestions on how to do this effectively? > > Thanks in advance for your input, > > SKIP > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
