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, [email protected] writes:
zLen = LENGTH($Dept$) _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
