• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

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!
0
SStroz
Asked:
SStroz
  • 2
1 Solution
 
James0628Commented:
The short answer is, use ' (single-quotes) around the string in CR.  For example:

 'to "ABC"'   (that's a single-quote at the beginning and end)


 If you need something more specific, post your formula.

 James
0
 
SStrozAuthor Commented:
This worked great!  So simple...yet when you don't know I wasted hours.  When will I learn to get to ee faster!

Thanks again!!!
0
 
James0628Commented:
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
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now