Extract String which has positive and negative numbers

[#1]

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.

[#2]

This is a tough one. Any wise advice?

[#3]

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

[#4]

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