14 Replies Latest reply: Aug 23, 2011 6:48 AM by Sunil Chauhan RSS

    field with number and alphanum source how to format it to string in edit script

    Ruby Otero

      hi,

      i have this problem

      an excel file field name PRODCD but with value of alphanum

      if the value of this field contains numeric, automatically excel expect it to be numeric, so if i have other  record with alphanum it will create confusion in loading.

       

      My question is how do i convert it during loading (in edit script) because i have a table with the same field name so that i can get full product name when i reload.