I need some help udf to get the data from fix values

[former_member452321]

source                      Target

z1ekko2 0..1                 Notes

                                        ID 0..1

                                                                                                                                  Text 1.1

          ZTANDC 0...1

          ZTANDC contains the values of X  for example 00xxxxx0000xxx

   We need to loop through the ztandc field up to 7 .If the seventh field has X then

             do (i=0; i>=7,i++)

                      If ztandc.substring(i.i+1) =X then

                      we need to append the  values from 0 to 6 to target Notes -Text field from fixed values corresponding to the values 0 to 6  The following sample fixed values  data

            0  Test1

    1  Test2

    2  Test3

             3  Test4

            4  Test5

            5  Test6

            6  Test7

            7  Test8

    8  Test9

Thanks for your help

Mahesh

[praveen_sutra]

Hi  Mahesh,

the structure you have provided is not very clear.

could you please allign it or better would be take a screen shot and attach.

thanks and regards,

Praveen T

[ambrish_mishra]

Mahesh,

You mention ZTANDC 0...1 ... how will you loop on it 7 times...

Ambrish