Then its even more simpler if every string is terminated with a semicolon.. it’s the number of semicolons in the string.. You’ll just have to make sure there none of the strings have consecutive semicolons with no value in between them..
Clean the logic that inserts the semicolons while adding or removing values from the string to ensure no consecutive semi colons in case you find some instead of having logic to consider that while counting the number of values.. Joe From: [email protected] Sent: Friday, June 03, 2011 2:10 PM Newsgroups: public.remedy.arsystem.general To: [email protected] Subject: Re: Workflow ** 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] 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. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
