Subject: Re: Stripping blank spaces before and after a word. Help

Jim Ault JimAultWins at
Thu Nov 2 11:42:22 EST 2006

> convert all text in a list to ALL CAPS
 look up "upper" in the docs.

> then wrap the data in 'single quotes' for SQL data entry
....numerous posts on this topic recently.
Do a search for "SQL" in the Rev archives to find several ways of doing SQL
formatting (merge, concatenation, function calls, replace) then choose your
own flavor.

Jim Ault
Las Vegas

On 11/2/06 10:04 AM, "Dave Herndon" <herndogy at> wrote:

> Thanks Mark,
>   I settled on this and it works SWEEEET !  Thanks For your help.  Now to
> finish it up.  Anybody have a good way to convert all text in a list to ALL
> CAPS?  It would be nice to get a consistent look in the database.  Here is the
> script I settled on.
>   repeat with x = 1 to the number of items of MyList
>   put word 1 to -1 of item x of Mylist into item x of Mylist
>   end repeat
>   Then I run another script to turn MyList containing mydata1,mydata2,mydata3,
> into 'mydata1','mydata2','mydata3' for entry int the databse.  Perhaps I can
> do it all in the same repeat loop.  Get rid of the spaces, change the text to
> all caps and then wrap the data in 'single quotes' for SQL data entry if the
> data is not a number or a date.  Anybody wanna throw down on this one?
>   Mark Wrote Dave,
> I think you are looking for something like this
> repeat for each item myVar in "var1,var2,var2"
>    do "put word 1 to -1 of" && myVar && "into" && myVar
> end repeat
> or
> repeat for each line myLine in fld 1
>    put (word 1 to -1 of myLine) & cr after myList
> end repeat
> put word 1 to -1 of myList into fld 1
> Best,
> Mark
>> Does anyone have a handy little script that could be put in a
>> repeat loop to evaluate either the contents of several fields, or a
>> comma delimitered list of variables, and strip any blank spaces
>> that may or may not exist from before and after the contents. To
>> ready the data for insertion into a database.  I am having an issue
>> with data being entered with spaces before of after the words,  and
>> then not showing up in a data query because of that.
>>   I usualy insert the datra from several fields into a list such as
>>   var1,var2,var3, etc before entering it into a database.
>>   Thanks
>>   Dave
> _______________________________________________
> use-revolution mailing list
> use-revolution at
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:

More information about the Use-livecode mailing list