868621_en-US

liliconcom

Extract String which has positive and negative numbers

Hi,

I have a table1.jmp as atteched. How do I extract the X and Y as circled in the red box? The X and Y values can sometimes be negative. For example, the XY values from the 1st row is -280,-396. The XY values from the 2nd row is 284,-228.

 

Automation and ScriptingRe: Extract String which has positive and negtive numbers

This is a tough one. Any wise advice?

Re: Extract String which has positive and negtive numbers

Here are the formulas that will do what you want

// For the X value
Num( Substitute( Word( 5, Substitute( :Fname, "--", "-&" ), "-" ), "&", "-" ) )

// For the Y value
Num( Substitute( Word( 6, Substitute( :Fname, "--", "-&" ), "-" ), "&", "-" ) )

 

Re: Extract String which has positive and negtive numbers

Regex can also be an option (https://regex101.com/r/5fgzrx/1 for partial explanation on how this works)

Num(Regex(:Fname, "-(-?\d{3})-(-?\d{3})", "\1"))

change "\1" to "\2" for Y