1 Reply Latest reply: Feb 23, 2016 12:18 PM by Olly Bond RSS

    template [ ] added to end of xls export

    brad onuch

      hi I have a template that I created as append data

       

      the type is character the width of the character set can be 3 to a max of 6 characters long.

       

      when I export the file to xls it adds [] brackets to the end of the 3 character set fields

       

      I have the display and template width set to 6 is this correct as I do not want those brackets in the export?

       

      tks b.

        • Re: template [ ] added to end of xls export
          Olly Bond

          Hello Brad,

           

          If you create a new Calculated field in the Table, using the expression strip(OriginalField;"[]"), does this affect the export?

           

          I suspect it might be not [] but something like □ - perhaps it is an end of line character which isn't being ignored.

           

          You might find that toggling the Ignore Print Control Characters setting in Options helps fix it.

           

          Best wishes,

           

          Olly