3 Replies Latest reply: May 15, 2014 10:07 AM by Data Kruncher RSS

    Truncated data while exporting to excel

    Amarjit _

      Hi,

       

      I am using Monarch V 7.00. I am struggling with the loss/truncated data I get after exporting it to the excel format. The excel format provides me with a maximum 20 characters in a single cell, If I convert a txt. format containg more than 20 characters to an excel format using Monarch, it truncates the data.

       

      e.g  "xxx-xxxxxxxxxxxxxxx-x" (21 characters) is being truncated to "xxx-xxxxxxxxxxxxxxx-" (20 characters), by Monarch while exporting it to an excel format.

       

      Please provide me a way to get complete data.

       

      Your help will be greatly appreciated.

       

      Thanks,

      Amarjit