AnsweredAssumed Answered

Trim Calculation Not Triming

Question asked by lindseym on May 2, 2018
Latest reply on May 2, 2018 by lindseym

I realize this is probably a user error issue. I had massive help writing this calculation.

 

What I want: The data returned with no leading space

What I get: a space in front of the data

 

I'm working on: FMP 14

 

I noticed this when I combined two substitutes there was an unwanted space. I created a new field and utilized the Length function. I did some other work, and I notice that the space is in front of the data. How can I alter the below calculation to remove that space? I have 5 ( I think) of these calculations with different substrings. Data length can be 1 character, or multiple words with spaces. Is there a way to show "hidden character" like in MS Word?

 

I thought the part in bold/red would get rid of the spaces... but I think I am interpreting it wrong. The rest of the calc is performing as desired.

 

 

Let (

    [

      ~string = Space ;

      ~substring = "Building" ;

      ~fail = "TBD"

      ] ;

 

 

      // -- core function, this is the actual function

 

    Case (

 

          // In order to start with simpler test, we first test the case where the substring is not contained in the script -> throw a failed test string (TBD or other) if true

 

      PatternCount ( ~string ; ~substring ) = 0 ; // This means the string does not contain the substring

                TextStyleAdd ( ~fail ; HighlightYellow ) ;

 

 

      // Else, we proceed to extrating alla the characters after our Substring

      // using FM native function, we determine the substring position in the string, the length of the string and then extract all characters after Position + Length

      Let (

                [

                ~lenString = Length ( ~string ) ;

                ~lenSubstring = Length ( ~substring ) ;

                ~posSubstring = Position ( ~string ; ~substring ; 1 ; 1 ) ;

                ~return = Middle ( ~string ; ~posSubstring + ~lenSubstring ; ~lenString )

                ] ;

 

                // At the end, we trim the result, so we get rid of any unwanted spaces

                GetValue ( Substitute ( ~return ; "-" ; ¶ ) ; 1 )        )

 

 

      )

 

 

// -- end of core function

 

 

) // closing first let statement

 

Thanks,

 

-L

Outcomes