Remove blank spaces and make lower case
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
Forum Discussion
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," "))
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," "))