Here is a formula that I believe will do the trick
degCPosition = Contains( :Source, "degc__" ) - 1;
i = degCPosition;
While( Substr( :Source, i, 1 ) != "-", i-- );
If( Substr( :Source, i - 1, 1 ) == "-",
result = Num( Substr( :Source, i, (degCPosition - i) + 1 ) ),
result = Num( Substr( :Source, i + 1, degCPosition - i ) )
);
result;
![position.PNG position.PNG](https://community.jmp.com/t5/image/serverpage/image-id/14261iDC7889AB86672574/image-size/large?v=v2&px=999)
Jim