[SOLVED] Python extract sub string in between two pattern excluding floating number

Issue

I am using python 2. I need to replace two sections in a string. For example something like below

str1 = "product,price=(decimals=4, value=7.505),quantity"
str2 = "product,(subporduct,(price=(decimals=4, value=7.05)),quantity"
str3 = "product,(subporduct,item=2, price=(decimals=4, value=7.05)),quantity"

I need the out put to be like this i.e. with price equals to the floating number

  1. product,price=7.505,quantity
  2. product,(subporduct,(price=7.05),quantity
  3. product,(subporduct,item=2, price=7.05),quantity

I tried this but it leaves the last bracket, otherwise it is good enough for me.

print(re.sub("(?<=price=).+?(?<=value=)", "", str1))

I need the solution in python 2

Solution

You can use

re.sub(r'(price=)\([^()]*?value=([\d.]+)\)', r'\1\2', str1)

See the regex demo. Details:

  • (price=) – Group 1 (\1): price= substring
  • \( – a ( char
  • [^()]*? – zero or more chars other than ( and ) as few as possible
  • value= – a literal substring
  • ([\d.]+) – Group 2 (\2): one or more digit or . chars
  • \) – a ) char.

The replacement is the concatenation of Group 1 and 2 values.

Answered By – Wiktor Stribi┼╝ew

Answer Checked By – Pedro (BugsFixing Volunteer)

Leave a Reply

Your email address will not be published. Required fields are marked *