Tibco Spotfire 7.5 and backslash character
can someone help me to understand why Mr. Spotfire does not recognize the "\" character?
I have a simple datatable A with a simple string column "COLUMN A" containing a string with "\" character ("XX\YYYYYYYYY" e.g.).
If I try to filter datatable rows to extract the row of a specifc value of COLUMN A with the following expression
[COLUMN A]="XX\YYYYYYYYY" return 0 result
instead if I create a calculated "COLUMN A1" where I replace "\" with "-" the expression
[COLUMN A1]="XX-YYYYYYYYY" is correctly evaluated.
I try also to apply the same logic filter with on demand mode of data table but doesn't work.
it seems that it does not recognize the character \.