Analysing Trackman Golf Data in JMP - Looking For Advice on modifying data structure to aid numerical and visual analysis

[#1]

I've recently started using Trackman App at my local golf swing studio.

I'm downloading the data and using JMP to analyse 

It's very early days of data collection but I have a particular question about modifying the data structure to make the trackman data more "analysable"

One of the things I'm interested in is strike position of the ball on the club face.

The way Trackman outputs the data is in a text column titled "impact height" and the data for each shot is in the the form of , for example - 4D, 2 U, 1 D ,0 where the number represents mm distance and the D or U represents whether the strike was "Down" or "Up" from the sweet spot on the club face (so "0" is a perfect strike exactly on the sweet spot; 4D is a strike 4 mm down from the sweet spot; 2U is a strike 2 mm up from the sweet spot etc.)

I would like to convert this text data into a positive or negative numerical value, where positive numerical value would be above the sweet spot, and negative numerical value would be below the sweet spot i.e. convert 4D into -4; 2U into +2. This would allow me to control chart the data etc etc

I'm guessing this conversion is some sort of formula but I'm not sure how to do it

I attach my JMP data table for reference (relevant column is "Impact height")

Any advice much appreciated

[#2]

One option for the formula could be something like this

dir = If(Right(:Impact Height, 1) == "D",
	-1
,
	1
);
Num(Substitute(:Impact Height, "D", "", "U", "")) * dir;