Hello
I have set up a New Column "Pin Name"
and would like to add a number of PIN
It means if you contain gp_0 in the column "Test Name" it should be GP_0
or if you have contains gp_1 in test name it should be GP_1 in Column "Pin Name"
or if you have contains gp_11 in test name it should be GP_11 in Column "Pin Name"
I wrote the script
Column(dt,"PIN_NAME") << Formula ( If ( Contains( :TEST_NAME, "gp_0" ), "GP_0",
If( Contains( :TEST_NAME, "gp_1" ), "GP_1",
If( Contains( :TEST_NAME, "gp_10" ), "GP_10",
If( Contains( :TEST_NAME, "gp_11" ), "GP_11",
If( Contains( :TEST_NAME, "gp_12" ), "GP_12" ))))));
but I see the formula add GP_1 even I have gp_11 in test name.
so my question is, how I can set exactly name for searching?
![Dennisbur_0-1696416826951.png Dennisbur_0-1696416826951.png](https://community.jmp.com/t5/image/serverpage/image-id/57209i2C813F32F75FC2D3/image-size/medium?v=v2&px=400)