Find text strings that either start or end with double quotes

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],' " ').

Tips and Tricks

Accepted answers

mlevitan

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.

All comments

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

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.

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335