• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to concatenate text strings that contain quotes

gjl

New Member
I have this query (in Excel) on a Hyperion Database. One of the lines reads like this:


<Link ((<LEV("Customers", "Lev0,Customers")) AND ( <IDESC("FRANCE")))


In this case FRANCE is a variable for a country. There are some 20 countries in all.

I get the name of the variable from another sheet and want to create a text string where the parts to the left and right contains quotes as part of the text.


"<Link ((<LEV("Customers", "Lev0,Customers")) AND ( <IDESC(""&A1&"")))" does not work because of the additional quotes. Any ideas
 
Try this


"<Link ((<LEV(""Customers"", ""Lev0,Customers"")) AND ( <IDESC("""&A1&""")))"
 
Back
Top