I put the semicolon in the wrong spot. It is actually IT Services; Accounting; Facilities; (the semicolon is on the end) In a message dated 6/3/2011 2:00:04 P.M. Eastern Daylight Time, [email protected] writes:
** 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]_ (mailto:[email protected]) Sent: Friday, June 03, 2011 1:42 PM Newsgroups: public.remedy.arsystem.general To: [email protected]_ (mailto:[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. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
