How can I escape "=" as part of a column name?

breinoso

How can I escape "=" as part of a column name?

I need to implement a "select where" statement and I am building it as a string, which involves multiple column names. But when it evaluates it is attempting to interpret the "=" as an assignment. My column names are like: "COND=TEMP".

Below the section of the script I use:

select_string = ":Test Name == benchNameToCompare";

//For each column in the map table, if the column name is a COND add it to the select criteria

For( j = 1, j <= numOfColumns, j++,

Current Data Table(correlationMapTable);

currentColumnName = correlationMapTable<<Get Column Names();

If(Contains(currentColumnName[j],"COND_")>0,

theValue = currentColumnName[j][i];

 

colName=currentColumnName[j];

select_string = select_string || " & As Column(correlationMapTable," || char(currentColumnName[j]) || ") == " || char(currentColumnName[j][i]);

 

);

);

select_string = "benchDataTable << select where(" || select_string || ")";

eval(parse(select_string)); //Here is complains if I have "=" as part of the column name.

benchDataTable << Subset(( Selected Rows ), Output Table Name("Filtered Bench Table"));

Thanks in advance!

msharp

I'll be honest, this script has a lot of issues.  My head hurts just thinking about debugging it.

So I'm not going to, but essentially your issue is this:

= doesn't need to be escaped what you need to escape is parenthesis​ ​quotation marks.  AKA:

eval(parse("dt << Select Where(Column("Cond=Temp") == 2)"));

needs to become:

eval(parse("dt << Select Where(Column(\!"Cond=Temp\!") == 2)"));