How to concatenate text strings that contain quotes « Chandoo.org - Learn Excel & Charting Online

How to concatenate text strings that contain quotes

(2 posts) (2 voices)

Tags:

Gert-Jan

Member
Joined: Mar '10
Posts: 23

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

Posted 2 years ago #
xld

Member
Joined: Sep '10
Posts: 233

Try this

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

Posted 2 years ago #