Hi,
We have Names with first character as whitespace and I'm trying to filter them so the team can fix them at the source.
Any ideas how we can filter out the list of names, where the first character is a white space?
Thanks
Jag
Solved! Go to Solution.
Hi @JAGBI
What about a filter tool, where you have a custom filter that searches for the white space in the first position?
For example,
StartsWith([Field1]," ")
Please let me know if that works for you
Cheers!
Esther
Hi Esther,
the StartsWith([Field1]," ") pulls all the names where the firstname is null.
Not sure if we have to use regex
Thanks
Jag
Hi JAGBI,
Please try this :
Left([Field], 1)=" "
to filter out the names starting with whitespace.
Hi @JAGBI
A small modification of @estherb47's solution handles the null values for you
not isnull([Name]) and startswith([Name]," ")
Dan