topic Re: extract information from a column in jmp in Discussions

extract information from a column in jmp

chandankishor66 — Fri, 09 Jun 2023 15:59:34 GMT

Hello JMP User,

I want to write a script to extract some particular information such Alc%, VA, RS% from :merge and put them in a separate columns. Alc, VA and gravity values are randomly distributed, therefore Recode column would worked iin this case

Any suggestions will be highly appreciated,

Regards,

Re: extract information from a column in jmp

txnelson — Mon, 03 Oct 2022 15:41:07 GMT

Here is an example script that should get you going with solving your problem. All of the functions used in the script are documented with examples in the Scripting Index, available under the Help pull down menu

Names Default To Here( 1 );
dt = Current Data Table();

For Each Row(
	If( Contains( :merge, "Alc =" ),
		:Alc % = Num( Word( 2, Substr( :merge, Contains( :merge, "Alc =" ) ), "=%" ) ) / 100
	);
	If( Contains( :merge, "Rs =" ),
		:Rs % = Num( Word( 2, Substr( :merge, Contains( :merge, "Rs =" ) ), "=%" ) ) / 100
	);
	If( Contains( :merge, "VA =" ),
		:VA ppm = Num( Word( 2, Substr( :merge, Contains( :merge, "VA =" ) ), "=p" ) )
	);
	If( Contains( :merge, "Approved" ),
		:Approved By = Word( 3, Substr( :merge, Contains( :merge, "Approved" ) ), " :" )
	);
);

Re: extract information from a column in jmp

chandankishor66 — Mon, 03 Oct 2022 16:30:26 GMT

Many thanks txnelson,

Your suggestion is working for me.