Using Spotfire Alanyst 14.0.3
I’m in the Data Canvas adding a filter via the "Add transformation" feature.
When I use the filter expression …
[customdata_name]~='Binary Pump : 1 : RunStart_Pressure_Actual'
… I get hundreds of rows (Binary Pump : * : RunStart_Pressure_Actual is the actual full string in the column customdata_name)
However, when I use…
[customdata_name]~='Binary Pump : * : RunStart_Pressure_Actual' (replacing only the character "1" with "*")
…I get no rows.
Why is the wildcard character not being recognized?
P.s. For reasons unknown to me LIKE is not available as a function to replace ~=.
>Solution :
~=The operator is used for regular expression matching in Spotfire, while * typically represents zero or more preceding elements in regular expressions, but in the example you provided, it was not correctly used as a wildcard.
To match any character (including numbers), you should use in regular expressions (dot), which represents any single character, and * to indicate that the preceding character can be repeated zero or more times.