How to remove tab spaces in text

Before comparing the text, I need to remove the empty spaces in the text.

The problem that I am facing is, that the space before my text is a tab space. 

question: How to remove any tab spaces in a text.

There is a basic function that can remove all spaces.

Replace(t, search, replace)Returns Text 't' after replacing all Text occurrences of 'search' with 'replace'.


Try it with search=" " replace=""


Or you can try one of the trim() functions.