escaping ' within a String 1

[kaeserea]

Hi!

I have to set a variable. The value of the variable should be

IF HVNL EQ 'S'

With -SET I have a problem:

-SET &IF_HVNL = 'IF HVNL EQ 'S''

The problem is the '' within the ''. How can I create the above outcome?

Thanx
Eva

 

[GrSw]

Hello Eva,

Use double ' :

-SET &IF_HVNL = ' IF HVNL EQ ''S'' ' ;


Hope this helps
Grzegorz

 

[FrankExp]

Hi Eva,

You can try this as well:

-SET &IF_HVNL = 'IF HVNL EQ ' | '''' | 'S' | '''';

By using 4 quotes you provide 1 quote in the code. This is a normal standard in several languages. Frank van de Kant

http://www.explicit.nl

 

[HankW]

Or maybe you can use a define somewhere or a compute;
HELP/I1=IF HVNL EQ 'S' THEN 1 ELSE 0 and use that check. Using this kind of assisting fields is useful in cases you have multiple IF factors and you need to figure out if all of them are true or one is. Also as sortfields if you need multiple subfoots or something like that.

In some cases I've noticed that comparing alpha fields causes some major headaches. Usually if you haven't used nodata commands and the database pops out a null value (usually after the DA has sworn there are no null values in that field).


Cheers,
Hank W.