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

    Loop through subfields in Script



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

      I have 3 fields in this table:



      -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.