Extract exact value

Help Studio
, ,
1

hi all,

thanks in advance

i am trying to extract value from below string

Scalloped Pave Diamond Ring in Platinum (1/2 ct) 5.5_OD backup. Note to vendor - Ring size:5.5.
System.Text.RegularExpressions.Regex.Match(CurrentRow(“Description-1”).ToString.ToLower,“(?<=ring size:)([0-9])?.?([0-9])”).Value
here i got result proper like 5.5
but below
Blue Nile Studio Crown Curved Diamond Ring in Platinum (1/3 ct. tw.) SZ 7. Note to vendor - Ring size:7.
here i want only 7 but i got result 7.
i dont want last full stop

2

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Match(CurrentRow("Description-1").ToString.ToLower,"(?<=ring size:)\d(\.\d)?").Value

Regards,

3

thank you so much :heart:

1 Like
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.