Extract Number from String

[TJ2]

I have a field [Data] in which I need to extract the number that has 3 decimal places. The delimiter is "-" however, there are multiple delimiters in multiple places. I believe Reg ex can do this, but I need some help. The Output field is the desired outcome.

[Luke_C · Accepted solution]

@TJ2 

I'm not a regex expert, but the below should work for you.

(\d+\.\d+)

[Emil_Kos]

Hi @TJ2,

I have prepared a workflow for you:

The output:

[TJ2]

Thanks!

[AdamR_AYX]

Hi @TJ2 

I'll offer a non-regex solution as an alternative

Workflow attached