Formula to search text including double quotation marks ("")
Gurus,
I have to search for a string of text in a field; the text includes quotation marks like this:
to "ABC"
So, the text includes the word to, a space, and then a value seperated by "".
I'm close but can't get it - can you help?
Thanks in advance!
I have to search for a string of text in a field; the text includes quotation marks like this:
to "ABC"
So, the text includes the word to, a space, and then a value seperated by "".
I'm close but can't get it - can you help?
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome.
I know what you mean. It doesn't matter how simple it is if you don't know it. :-)
CR makes this easy because it accepts both single and double-quotes as string delimiters. You can even use both in the same formula, so if you needed a string that contained "'" (a single-quote inside double-quotes), you could use:
'"' + "'" + '"' (single-double-single + double-single-double + single-double-single)
(If you copy and paste that into something else, like the CR formula editor, or just something like Notepad, it's a lot easier to see. The quotes all blend together in my browser)
James
I know what you mean. It doesn't matter how simple it is if you don't know it. :-)
CR makes this easy because it accepts both single and double-quotes as string delimiters. You can even use both in the same formula, so if you needed a string that contained "'" (a single-quote inside double-quotes), you could use:
'"' + "'" + '"' (single-double-single + double-single-double + single-double-single)
(If you copy and paste that into something else, like the CR formula editor, or just something like Notepad, it's a lot easier to see. The quotes all blend together in my browser)
James
ASKER
Thanks again!!!