include �quotation marks� in a string?

[Daniel Weiss]

Is it possible to include �quotation marks� in a string? As for example, A=�abc�def� (abc�def) if yes, what is used before and/or after the quotation mark?
Thank You
Daniel Weiss

[csda1]

RE: include �quotation marks� in a string?

Daniel,

There are three methods.

1. If you are not using the single quote in the string, then

A='abc�def'

2. If you are using a single quote in the string, then

A=�abc�+chr(34)+"def�

3. Finally, you can use the backslash character as in

A=�abc�def�

This encodes the string as " but many Alpha functions strip the out.

I recommend 1 or 2 unless you don't have the option.

Regards,

Ira J. Perlow
Computer Systems Design & Associates
[email protected]

[Daniel Weiss]

RE: include �quotation marks� in a string?

Thanks Ira
What I actually needed is to set the fields for group rows by in a Crosstab operation via a Variable with markings between each fields

This is what I used

A = "alltrim(Stock_Item)+"+chr(34)+" - "+chr(34)+"+alltrim(Hinge)+"+chr(34)+" - "+chr(34)+"+alltrim(finish_end)"

then

A = strtran(A,"''") to remove the

It works fine

Daniel Weiss

[CALocklin]

RE: include �quotation marks� in a string?

Ira must have sent the note without checking the results. Here's what he wanted (I hope it comes out right for me!):

3. Finally, you can use the backslash character as in

A=�abc\�def�

[Daniel Weiss]

RE: include �quotation marks� in a string?

The forward slash didn�t show I try again

Thanks Ira
What I actually needed is to set the fields for group rows by in a Crosstab operation via a Variable with markings between each fields

This is what I used

A = "alltrim(Stock_Item)+"+chr(34)+" - "+chr(34)+"+alltrim(Hinge)+"+chr(34)+" - "+chr(34)+"+alltrim(finish_end)"

then

A = strtran(A,"'[]'") to remove the []

It works fine

Daniel Weiss

[CALocklin]

RE: include �quotation marks� in a string?

Daniel, to get the backslash character to show, use this string in its place:

\

What many do on this board is use something like the forward slash or vertical slash instead.

[Daniel Weiss]

RE: include �quotation marks� in a string?

Well this should show
A = strtran(A,"' forward slash '")
to remove the forward slash

[csda1]

RE: include �quotation marks� in a string?

Cal,

Ooops! I thought it ate forward slashes not backwards slashes!

Thanks for keeping me honest! A hundred slashes for pentance!

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

--Ira



Cal Locklin wrote:
-------------------------------
Ira must have sent the note without checking the results. Here's what he wanted (I hope it comes out right for me!):

3. Finally, you can use the backslash character as in

A=�abc\�def�

[Daniel Weiss]

RE: include �quotation marks� in a string?

Thanks Ira and Cal
Maybe one of you can help with this

Why is this happing?
If I put the following statement in the interactive window it strips the backslash�s

a="alltrim(Stock_Item)+"+chr(34)+" - "+chr(34)+"+alltrim(Hinge)+"+chr(34)+" - "+chr(34)+"+alltrim(finish_end)"

b=strtran(a,"''");?b

I get this result
alltrim(Stock_Item)+" - "+alltrim(Hinge)+" - "+alltrim(finish_end)

But if I write the second line like this
?strtran(a,"''")

or if I use it in a script it doesn�t strip the backslash�s

Any suggestion I need to strip the backslash�s, I need the result to be
alltrim(Stock_Item)+" - "+alltrim(Hinge)+" - "+alltrim(finish_end)

Thanks for your help
Daniel weiss

[Daniel Weiss]

RE: include �quotation marks� in a string?

Oops! i gess i cant win when i need the slaseh it disapears when i want to get rid of them i'm out of luck

Thanks Ira and Cal
Maybe one of you can help me with this

Why is this happening?
If I put the following statement in the interactive window it strips the backslash�s

a="alltrim(Stock_Item)+"+chr(34)+" - "+chr(34)+"+alltrim(Hinge)+"+chr(34)+" - "+chr(34)+"+alltrim(finish_end)"

b=strtran(a,"'chr(92)'");?b

I get this result
alltrim(Stock_Item)+" - "+alltrim(Hinge)+" - "+alltrim(finish_end)

But if I write the second line like this
?strtran(a,"'chr(92)'")

or if I use it in a script it doesn�t strip the backslash�s

Any suggestion I need to strip the backslash�s, I need the result to be
alltrim(Stock_Item)+" - "+alltrim(Hinge)+" - "+alltrim(finish_end)

Thanks for your help
Daniel weiss

[CALocklin]

RE: include �quotation marks� in a string?

Daniel,

I can't see a way to get exactly what you want. Could you tell us what the end result will be? If we know what are you trying to do with the final expression, someone might be able to suggest another way.

Cal