topic Re: Extract String which has positive and negtive numbers in Discussions

Extract String which has positive and negative numbers

cchueng — Wed, 21 Jan 2026 14:24:04 GMT

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.

Re: Extract String which has positive and negtive numbers

cchueng — Wed, 16 Apr 2025 14:38:01 GMT

This is a tough one. Any wise advice?

Re: Extract String which has positive and negtive numbers

txnelson — Wed, 14 Jan 2026 20:28:16 GMT

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

jthi — Tue, 20 Jan 2026 20:04:44 GMT

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