Improve company productivity with a Business Account.Sign Up

x
?
Solved

Formula to search text including double quotation marks ("")

Posted on 2009-05-19
3
Medium Priority
?
262 Views
Last Modified: 2012-05-07
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
Comment
Question by:SStroz
  • 2
3 Comments
 
LVL 35

Accepted Solution

by:
James0628 earned 2000 total points
ID: 24428661
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
 
LVL 7

Author Closing Comment

by:SStroz
ID: 31583354
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
 
LVL 35

Expert Comment

by:James0628
ID: 24483217
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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
When you have multiple client accounts to manage, it often feels like there aren’t enough hours in the day. With too many applications to juggle, you can’t focus on your clients, much less your growing to-do list. But that doesn’t have to be the cas…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

588 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question