Solved

How to evaluate a string that contains single quote when that is the  special characters used to define a string value.

Posted on 2014-07-21
3
283 Views
Last Modified: 2014-07-21
All,
I have a string that contains a single quote in it (EX:  Master's).  I need to evaluate a data item value to that string.  The problem is that the special character used to define string value is the single quote (').  Is there a way for me to evaluate this string as is without having to temporarily strip out the character to do the evaluation.  If not what is the simplest way to do the evaluation?  Thanks.

Ken
0
Comment
Question by:ktQueBIT
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
Randy Poole earned 500 total points
ID: 40209664
just double the '' as in 'Master''s' when evaluating it
0
 

Author Comment

by:ktQueBIT
ID: 40209721
Randy.  Thanks I think I tried every combination except that one.   You just saved me some major aggravation!!
0
 
LVL 21

Expert Comment

by:Randy Poole
ID: 40209725
No problem :)
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

770 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