Stripping blank spaces before and after a word. Help

[Mark Schonewille]

Hi 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

--

Economy-x-Talk
Consultancy and Software Engineering
http://economy-x-talk.com
http://www.salery.biz

Get your store on-line within minutes with Salery Web Store software.  
Download at http://www.salery.biz

Op 1-nov-2006, om 18:54 heeft Dave Herndon het volgende geschreven:

> 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