Leading zeros dropped when mapping to excel schema

David Paras

• August 16, 2013 20:57

excel schema
field defined as numeric
xml input <Zip>07307</Zip>
excel output 7307

please advise on how to prevent leading zeros from being dropped when a number is being mapped into an excel field that has been defined as numeric.

0

• 

  David Paras

  • August 16, 2013 20:58

  Leading zeroes can be handled inside the data mapping as the XML generated from the mapping will contain the leading zero whereas when the same input is passed to excel then it will automatically remove those leading zeros and the Excel File generated would not contain those leading zeros.

  As a workaround you can select the Field type of that field as string instead of the number while creating the Excel Schema and the leading zeroes will be retained in the target excel file with a single quote.

  0

Post is closed for comments.