I have the following data in one cell. (The length of the data varies not a fixed width format)
Measurement: Ring Head Width: 6.8 Ring Height: 5.5 Ring Shank Width: 1.1 Band Width: 2.5
I want to extract part of the above string.
Ring Head Width: 6.8
I am using the function "
Extract string parts" with the following regex code to extract to the new column.
\bRing Head Width: (\d+(\.\d+)?)
I have also tried.
Ring Head Width: (\d+(\.\d+)?)
But when I Submit to execute it a new column gets created but it has no data matching the regex ?
What am I doing wrong. I tried to look for examples in help documentation but could not find any.
Any help is appreciated.