Hello everyone, I would like to create a column from this column: if the term "H9" appears, put only H9 on the new column and I do not know how to do? Thanks
![NetflixCrow956_0-1655108752834.png NetflixCrow956_0-1655108752834.png](https://community.jmp.com/t5/image/serverpage/image-id/43189i5300CFC6C2C02086/image-size/medium?v=v2&px=400)
If( Column(dt,"Operation Status") << Left( HOLD, Contains( Hold,"9" ) ),
dt<< New Column ("status", character , "Nominal");
);