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

[Jim Ault]

> 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.
http://www.mail-archive.com/use-revolution@lists.runrev.com/

Jim Ault
Las Vegas

On 11/2/06 10:04 AM, "Dave Herndon" <herndogy at sbcglobal.net> 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 lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution