operation column

[#1]

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

If( Column(dt,"Operation Status") << Left( HOLD, Contains( Hold,"9" ) ),
dt<< New Column ("status", character , "Nominal");
);

[#2 · Accepted solution]

Here is one solution

Names Default To Here( 1 );
current data table << New Column( "Is Hold",
	character,
	formula,
	If( Contains( Words( :Operation Status, ", " ), "H9" ),
		"H9",
		""
	)
);