Hi,

I need to come out with a policy where I need to split an IDV attribute
value with delimiter = ";" and then store each split value into
different database column.

IDV Attribute value = "24000001;LINE OF CREDIT;FOO
JIEN1;ICS;ICS24000001;TESTING
ROLE;CREATION;20120222093749Z;FAIL;10001;FD1;FD2;F D3;FD4;FD5;FD6;FD7;FD8;FD9;FD10;FD11;FD12;FD13;FD1 4;FD15;FD16;FD17;FD18;FD19;FD20"

<do-set-local-variable name="lv.ambgICSAudit" scope="policy">
<arg-string>
<token-op-attr name="ambgICSAudit"/>
</arg-string>
</do-set-local-variable>
<do-for-each>
<arg-node-set>
<token-split delimiter=";">
<token-local-variable name="lv.ambgICSAudit"/>
</token-split>
</arg-node-set>
<arg-actions>
<do-set-dest-attr-value name="DEPT_SECTION">
<arg-value>
<token-xpath expression="count(./preceding::*)+1"/>
</arg-value>
</do-set-dest-attr-value>
</arg-actions>
</do-for-each>

I am able to get a local variable lv.ambgICSAudit with splitted value
and the current node value for eg.24000001. But I am having problem when
I want to detect the position of the value in the current node and to
populated the correct node value into correct database column.

For eg. I want to store the value "LINE OF CREDIT" into destination
attribute called "DEPT_SECTION".

Need help guys.......thanks


--
kaylayap
------------------------------------------------------------------------
kaylayap's Profile: http://forums.novell.com/member.php?userid=94293
View this thread: http://forums.novell.com/showthread.php?t=452502