Home > OS >  Find a string and replace it with another string with regex?
Find a string and replace it with another string with regex?

Time:05-14

I have a text file with below format:

Available Text1

Id                = 0005      
 Cause          = ERROR      
 Code     = 307      
 Event Time              = 2020-11-09 10:16:48      
 Severity      = WARNING      
 Severity Code = 5     
 result       = 2015-06-12 10:19:47
 Id                = 0006      
 Cause          = FAILURE      
 Code     = 517      
 Event Time              = 2020-11-09 10:19:47      
 Severity      = MINOR      
 Severity Code = 4 result = noresult 
 ip[10.1.1.1

I want to find result = in each text file and fulfill the value with the IP.

Requested Data

 Id                = 0005      
 Cause          = ERROR      
 Code     = 307      
 Event Time              = 2020-11-09 10:16:48      
 Severity      = WARNING      
 Severity Code = 5     
 result = 10.1.1.1
 Id                = 0006      
 Cause          = FAILURE      
 Code     = 517      
 Event Time              = 2020-11-09 10:19:47      
 Severity      = MINOR      
 Severity Code = 4 
 result = 10.1.1.1
 ip[10.1.1.1

I used the below code, but it only finds no result value and replace it with IP however there is a datetime value (2015-06-12 10:19:47) with comes in another line as the value of result. How can I use a regex to first find any value after result= and then replace it with IP?

for filepath in file_list:
    txt = open(filepath, "r").read()
    txt = txt.replace("noresult", txt.split("ip[")[-1])
    open(filepath, "w").write(txt)

CodePudding user response:

I would suggest to try with str.rfind or str.rsplit along with re.sub:

import re

s = """\
Id                = 0005
 Cause          = ERROR
 Code     = 307
 Event Time              = 2020-11-09 10:16:48
 Severity      = WARNING
 Severity Code = 5
 result       = 2015-06-12 10:19:47
 Id                = 0006
 Cause          = FAILURE
 Code     = 517
 Event Time              = 2020-11-09 10:19:47
 Severity      = MINOR
 Severity Code = 4 result = noresult
 ip[10.1.1.1
"""

# len('ip[') == 3
ip_addr = s[s.rfind('ip[')   3:].rstrip('\n')
s = re.sub(r'(result\s*=).*', rf'\1 {ip_addr}', s)
print(s)

Out:

Id                = 0005
 Cause          = ERROR
 Code     = 307
 Event Time              = 2020-11-09 10:16:48
 Severity      = WARNING
 Severity Code = 5
 result       = 10.1.1.1
 Id                = 0006
 Cause          = FAILURE
 Code     = 517
 Event Time              = 2020-11-09 10:19:47
 Severity      = MINOR
 Severity Code = 4 result = 10.1.1.1
 ip[10.1.1.1

CodePudding user response:

So you want to replace result=ANYTHING to result=IP. In this case you may use re.sub() with a regular expression that matches every thing after "result=".

import re
re.sub(r"result =[^\n] ","result = ip[10.1.1.1",txt)

The [^\n] will match every char in a single line.

To extract the IP from the text and do the replacement:

ip=re.findall(r"\b(?:[0-9]{1,3}\.){3}[0-9]{1,3}\b",txt)[0]

txt=re.sub(r"result =[^\n] ","result = " ip)
  • Related