Datagrid column of data with trailing spaces

[Skip Kimpel]

Aha.... You hit in something.... It IS coming from a SQL database.... Eliminate the problem before it gets into a datagrid.  Let me play with that.

In any case you were ALL very helpful... As always.

Very much appreciated.

SKIP

> On Jul 14, 2014, at 5:47 PM, Peter Haworth <pete at lcsql.com> wrote:
> 
> One other thought.  Is the data coming for an SQL database?  If so then
> this will do it for you:
> 
> SELECT rtrim(<columnname>) FROM......
> 
> 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
> _______________________________________________
> 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