Skip to main content
Question

Remove blank spaces and make lower case

  • March 2, 2017
  • 0 replies
  • 69 views
Forum|alt.badge.img+8
I would like to create a text formula that removes blank spaces and changes text to lower case. For example: 
[Field A] = New York City
[new formula field] = newyorkcity

thanks
      This topic has been closed for replies.

      • ChrisChris
      • Registered
      • March 2, 2017

      This formula text field removes up to four embedded spaces. You can understand the logic and add more Part() function terms if your strings have more spaces embedded.

      Lower(
      Left([Field to fix]," ")&Part([Field to fix],2," ")&Part([Field to fix],3," ")&Part([Field to fix],4," ")
      )

      Forum|alt.badge.img+8
      • BradElmore
      • Author
      • Registered
      • March 2, 2017
      Ended up using a solution the Mark suggested awhile back.....

      If I used:  Lower(Part([City], 1," ") & Part([City], 2," ") then New York City would become: newyork (no city)

      So I had to add a few more "Parts"
      Lower(Part([City], 1," ") & Part([City], 2," ") & Part([City], 3," ") & Part([City], 4," "))
      • BrandonLopez1
      • Registered
      • November 14, 2023

      I was looking for something similar and figured I'd post what worked for me. I used SearchAndReplace combined with Upper in my situation but you can use Lower.

      SearchAndReplace(Lower([Field A]), " ", "")

      Doing it this way does not require multiple Parts.

      Here is the function reference I used.



      ------------------------------
      Brandon Lopez
      ------------------------------
      Terms & ConditionsAccessibility statement