Datagrid column of data with trailing spaces

[Peter Haworth]

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 <
skip at magicgate.com> 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
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>