That’s because you must be replacing not just the ; but the space near it too..
Joe From: oracle...@aol.com Sent: Friday, June 03, 2011 4:47 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Re: Workflow ** For some reason the zInt field is not calculating the value as 3. I get the value of 6 instead in the zInt field. I selected IT Services; Accounting; Facilities; For example the zTmp field displays: Services;[space] Accounting;[space]Facilities; The $dept$ field values pass into zTmp and contains a space in between each dept so there are 2 spaces total. Isn't there a way to calculate that there are 2 spaces. I want to run an IF condition that states if the zInt field has 2 or spaces, then execute an action. In a message dated 6/3/2011 2:03:53 P.M. Eastern Daylight Time, thad.es...@gmail.com writes: zLen = LENGTH($Dept$) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
