Removing unnecessary blank spaces at the end of an entry...

MichaelTamoush
Qrew Captain
4 years ago
Not all spaces (I realized I wrote JohnSmith instead of 'John Smith'). Trim does not take spaces out from the middle of words (Like 'Van Halen'), It simply removes any leading and trailing spaces.

So: 'Van Halen___' becomes 'Van Halen'.

Though, what you mentioned isn't a bad idea either. You can use SearchandReplace and replace every space with a blank...and just have it be one run on word...that way lazy employees can't start adding extra spaces to the middle...

------------------------------
Mike Tamoush
------------------------------
- ChrisNewsome
  Qrew Captain
  4 years ago
  Great! This was a simple and elegant solution, I'll post back when I've implemented it, thanks!
  
  ------------------------------
  Thanks,
  Chris Newsome
  ------------------------------
- ChrisNewsome
  Qrew Captain
  4 years ago
  So I'm curious, how would SearchandReplace work? I've never used that function before.
  
  ------------------------------
  Thanks,
  Chris Newsome
  ------------------------------
  - MichaelTamoush
    Qrew Captain
    4 years ago
    This would replace spaces with nothing (note i Have a space in the first set of quotes:
    SearchandReplace([My Field], " ", "")
    
    So that says, search My Field for any space, and replace it with nothing.
    
    Quickbase's description below.
    
    SearchAndReplace (Text textToSearch, Text searchText, Text replacementText)
    
    Description: Replaces ALL occurences of a given search text with the replacement text. Search is case sensitive.
    
    Example: SearchAndReplace("John Smith", "John", "Jane") returns "Jane Smith"
    
    ------------------------------
    Mike Tamoush
    ------------------------------

Forum Discussion

Removing unnecessary blank spaces at the end of an entry...