3 Replies Latest reply: Dec 13, 2012 5:38 PM by Celambarasan Adhimulam RSS

    Loop through subfields in Script

      Hi

       

      I have created an ODBC link to one of our tables from our accounting system.

      I have 3 fields in this table:

      -year

      -entity

      -amount (this field consists of 12 subfields for each month. The months are separated by '; ' ).

       

      How do i update this table so it has 4 fields

      - year

      - entity

      - month

      - amount

       

      I know how to separate the amount - subfield(amount, ";" ), but i don't know how to create a new field for month.  That is, the first subfield will have a month of January, the second subfield will have a month of February etc.

       

      Your help will be greatly appreciated.

       

      Regards