2 Replies Latest reply: May 15, 2014 10:01 AM by Data Kruncher RSS

    Removing Spaces before an Amount

    Matixsnow _

      Can anyone tell me how to remove blank spaces before an amount or text that I want to capture in the report?  I cannot figure it out.

       

      Thanks,

      Jeff

        • Removing Spaces before an Amount
          Grant Perkins

          Jeff,

           

          I'm not sure about the concept of removing spaces before an amount since the size of numeric fields (if you are using numeric fields) is normally self regulating and right justified, but other than that have a look at the TRIM related functions - TRIM, LTRIM, RTRIM. In V9 perhaps INTRIM although your immediate needs seem more specific than that.

           

          HTH.

           

           

          Grant

           

          Edit: Should have added that you need to create a calculated field to do this.

            • Removing Spaces before an Amount
              Data Kruncher

              If your desired end result is a numeric field and you're starting with a character field, you will need to use the Val function. The Val function handles the removal of any leading or trailing spaces by itself; you won't need to use a Trim function.

               

              But as Grant mentioned, you will need one of the Trim functions for character fields.