Two potential issues.
1. Is your database Unicode? It'd probably be better to use LENGTHC()
instead of LENGTH()
2. In your replace action:
REPLACE($Dept$, ";", "")
Make sure that there isn't a space between the double quotes in either
of the last two parameters. It should just be ";" and then "" (no space).
If the above replace is done right, the zTmp field won't have any semicolons
in it.
Here's an annotated log snippet:
$Dept$ input is "IT Services; Accounting; Facilities;"
----------
<ACTL> Checking zzzTest:Count It (0)
<ACTL> -> Passed qualification -- perform if actions
<ACTL> 0: Set Fields
<ACTL> zTmp (536870920) = IT Services Accounting
Facilities // set fields action: REPLACE($Dept$, ";", "")
<ACTL> 1: Set Fields
<ACTL> zInt (536870922) = 33 // set fields action:
LENGTHC($zTmp$)
<ACTL> zLen (536870921) = 36 // set fields action:
LENGTHC($Dept$)
<ACTL> 2: Set Fields
<ACTL> valueCount (536870923) = 3 // set fields action:
$zLen$ - $zInt$
<ACTL> /* Fri Jun 03 2011 14:02:10 */
----------
Thad
On Fri, Jun 3, 2011 at 1:47 PM, <oracle...@aol.com> wrote:
> **
> 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$)
>
> _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"
