RegEx Columns

Hi Guys,

I have been playing around with Column - Custom Text and Regexp by @wowbagger.

I have created ColumnX for the files below showing the X value (whatever that is).

Clipboard%20Image

I have used the following expression to grab the values:

This works fine for the integer values but I can't work out how to grab the decimal values. The decimal values can range between 0.1x and 99.9x.

Any help would be much appreciated.

Regards

Blueroly

Try [0-9.]+ instead of \d{1,2}.

3 Likes

That worked. Thanks @lxp