Unless I have not understood what you want right, I think this is fairly simple..
If there is no semi colon after the last value, count the number of semi colons in the string, by running a loop on the string while looking for the semicolon using something like strstr() and then add 1 to get the number of values separated by semicolons... If there are some strings that end with a semi colon, then add some sub logic to see what the final character in the string is... Cheers Joe From: [email protected] Sent: Friday, June 03, 2011 1:42 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Workflow ** Hi, I want to count the multiple values within 1 field that are separated by a semicolon ; For example: The Dept field contains ----- IT Services; Accounting; Facilities I want to set another field with the value of 3. I am not sure what command I can use to count the semicolons. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
