> 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/[email protected]/ Jim Ault Las Vegas On 11/2/06 10:04 AM, "Dave Herndon" <[EMAIL PROTECTED]> 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 > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
