Find text strings that either start or end with double quotes

[mlevitan]

I'm trying to find text strings that either start or end with double quotes. No luck using single quotes around the double quote using the findstring function (FINDSTRING([string],' " ').

[MarqueeCrew]

@mlevitan,

left([Field1],2) == '""'
OR
right([Field1],2) == '""'

Cheers,

Mark

[mlevitan]

Thanks for the response. Unfortunately, I'm still getting the same result (zero), which I suspect means that Alteryx doesn't pick up the double quotes in the Left or Right formula.

I imported this file from MS Excel from a copy / paste from Word, so might that have something to do with them not being recognized?

[MarqueeCrew]

I did test that formula and it does work.  It is possible that the character set for the quotes are "smart" or "curly".  Can you post some sample data?

[mlevitan · Accepted solution]

The source data had open and close characters rather than double quotes, which was why Alteryx wasn't able to pick them up. I changed the source data and it now works.

Thanks for the help.