A simple script to accomplish the removal of blank spaces (in field 
"datafield") is as follows:

repeat with x = 1 to the number of chars in field "datafield"
     if char x of field "datafield" is " " then delete char x of field 
"datafield"
   end repeat

Steve Goldberg

In a message dated 11/2/06 1:02:47 PM, 
[EMAIL PROTECTED] writes:


> 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.
> 

_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to