Find Names with first character as white space

[JAGBI]

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

[estherb47]

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

[JAGBI]

Hi Esther,

the StartsWith([Field1]," ") pulls all the names where the firstname is null. 

Not sure if we have to use regex

Thanks

Jag

[ankit_mandal]

Hi JAGBI, 

Please try this : 

Left([Field], 1)=" "

to filter out the names starting with whitespace.

[danilang · Accepted solution]

Hi @JAGBI 

A small modification of @estherb47's solution handles the null values for you

not isnull([Name]) and startswith([Name]," ")

Dan

[estherb47]

Hi @JAGBI 

I did not catch that your original data had null values as well. Looks like @danilang 's modification of my solution should work perfectly!

Cheers to solving together :)

Esther