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]



      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



      Expected output (without leading and trailing spaces):

      ABC123,773.22,Description Text,DEF456