This script pretty much gets the job done. Stripps unwanted spaces before
and aft, changes mixed or small caps to ALL CAPS, and makes ready the data for
SQL data entry by wrapping the list items with 'singlequotes'
on mouseUp
put field "data" into MyList
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
put "'" & item x of Mylist & "'" into item x of mylist
end repeat
put the toUpper of Mylist into MyList
put Mylist into field "recip"
end mouseUp
the script changes
davo, davo , davo Herndon , davo,davo,davo , davo , davo,
TO
'DAVO','DAVO','DAVO HERNDON','DAVO','DAVO','DAVO','DAVO','DAVO',
Now if I can just check to see if the item is a number or a date and not do
the single quote operation on those items I will be set. As a work around I
have beem carefull to leave those items as the last items in the list and do a
partial operation, say there are 6 items in the list to be added to a database
record and the last two items are dates.
as in varchar1,varchar2,varchar3,varchar4,date1,date2
repeat with x = 1 to 4
put "'" & item x of Mylist & "'" into item x of mylist
end repeat
returns 'varchar1','varchar2','varchar3','varchar4',date1,date2
_______________________________________________
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
