Extract String parts Via Regex

_AnonymousUser — Sat, 16 Nov 2024 10:15:32 GMT

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.

Re: Extract String parts Via Regex

Anonymous — Sun, 13 Nov 2016 20:39:01 GMT

Hi,

This one should do the trick:

: ([a-zA-Z ]*: \d\.\d)

A quick explanation. What you want to capture is after the first occurence of ": " and is compound by the following elements, in that order:
[list=1]

A mix of uppercase, lowercase and spaces.

A colon

A space

A digit

A dot

A digit

Regards,

Gwendal

topic Extract String parts Via Regex in Data Quality

Extract String parts Via Regex

Re: Extract String parts Via Regex