552030_en-US

liliconcom

extract information from a column in jmp

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,

 

 

Data Blending and CleanupRe: extract information from a column in jmp

 

Many thanks  txnelson,

Your suggestion is working for me.

Re: extract information from a column in jmp

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