If you were to replace the semicolon's with Null values, then the difference in length between the two strings would give you a count.
zLen = LENGTH($Dept$) zTmp = REPLACE($Dept$,";","") zInt = LENGTH(zTmp) valueCount = (zLen - zInt) + 1 (assumes pre-check for non-null) Of course, you could combine all that into one action. Depending on your rules for semi-colon placement you may need to change the "+1" part. Thad On Fri, Jun 3, 2011 at 10:42 AM, <[email protected]> wrote: > ** > 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"
