You could do something like ELSEIF REPLACE([Location], '"', '') = "store Z"
That is a double quote inside two single quotes in the second argument, and then two single quotes in the third argument. This should remove all the quotation marks from the Location field. It is strange that wrapping "store Z" in single quotes isn't working though.
- use apostrophe (') as text qualifier or
- replace each quotation mark in text with two (three inclusive text qualifier):
Qualifier Text Formula 1 ' " ELSEIF [Location] = '"store Z"' 2 " "" ELSEIF [Location] = """store Z"""
If this doesn't work, could you share exact text of [Location]?
Thank you both for your responses. I went with the quick solution of """ """ this time around but will definitely keep the others in mind.
You are welcome
It would be helpful if you marked the solution you used as correct (a green star).
Ps. I wonder if the reason that you have quotation marks in the "database field" is because you are connected to a text file with " as text qualifier? See what I mean in gif screen recording below:
Date Store Amount 2016-09-27 "store Z" 1000
the dataset is from excel and that is the only location out of a few hundred that has " at the beginning and end of the location name. thanks again!