You can use SSUB with a negative position number to retrieve values from a space delimited list.
-1 will retrieve the first word and -2 will get the second, etc You can build an appropriate search string this way. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Castanaro, Bob Sent: Tuesday, June 02, 2009 2:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Checking for spaces in an eep List, I have a database of information that has 6 keyword fields for lookup purposes. I wanted to limit the keyword to just that - one word. Unfortunately the users seem to have an issue with this and many times put in two words - thus rendering the keyword search and concept moot. Is there an elegant way to check for a space and then return to the field in an eep? Is this better to check in rules??? Anybody have good ideas they are well appreciated... Thanks Robert M. Castanaro Director, Surgical Services, Clinic and Pain Services Summa Health System Barberton Hospital 155 Fifth Street N.E. Barberton, Ohio 44203 Phone 330-615-3627 [email protected] [cid:[email protected]]
