operation column

NetflixCrow956 — Fri, 09 Jun 2023 17:01:08 GMT

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");
);

Re: operation column

txnelson — Mon, 13 Jun 2022 08:50:43 GMT

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",
		""
	)
);

topic Re: operation column in Discussions

operation column

Re: operation column