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