Extract String which has positive and negtive 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, "--", "-&" ), "-" ), "&", "-" ) )