4 Replies Latest reply: May 15, 2014 10:10 AM by mdyoung _ RSS

    Leading and Trailing Spaces in Export

    mdyoung _

      [B]Version[/B]: Monarch Pro v10.5[/I]

       

      :confused:

      I have a simple report in which all fields are character based and I have to export the columns out to a CSV file. However, when exported, the leading and trailing spaces are included. Is there a way to have Monarch automatically remove these spaces upon export? I know that I can create a calculated field for each field using the TRIM function, but I'd really like to avoid it if possible because there's quite a few columns.

       

      For example:

       

      Current output looks like this:

      ABC123,   773.22,Description Text,   DEF456

      /CODE

       

      Expected output (without leading and trailing spaces):

      ABC123,773.22,Description Text,DEF456

      /CODE

       

      Thanks,

       

      Micheal