I have a form that checks for duplicate names (these are first and last names within one field) but I would like the script to ignore any spaces at the end or before the text (but not if there is a space between words) no matter how many words are in the field. For example, the current script would not catch Firstname Lastname(space) being the same as Firstname Lastname(no space) hence no duplicates detected. Anyone know how to update this? I seem to break it every time I try. The form is located here: https://drive.google.com/drive/folders/1gneWXGTgzvCEeZHBxumR3v429X6nBzbJ?usp=sharing