Simple script to remove value from line, output printing twice at end

[Colloid Snake]

Hello,

I'm running into an odd problem - well, at least I think it's odd, but that's probably because I have a Cygwin screen burned into my retinas from staring at it for so long. When I run my script below, the output lines print twice. I'm hoping it's something simple (and yet kind of not, because then I look like a fool... oh well), but hopefully a fresh pair of eyes might be able to help me.

Oh, and please feel free to comment on how I'm removing the data - I found a QAD way, but I'm guessing there might be a better way.

s_fileToParse = "/opt/www/status.html"
s_SummaryFile = "/home/user/weeklyReport.txt"
l_linesToRead = []
i_configured = 0
i_down = 0
FILE = open(s_fileToParse,"r")
 
l_linesToRead = FILE.readlines()
 
for s_lines in l_linesToRead:
  if s_lines.startswith("Total"):
    # parse for number between <B> and </B>
    s_lines = s_lines.lstrip("Total # Configured: <B>")
    s_lines = s_lines.rstrip("</B><BR>\n")
    i_configured = int(s_lines)
  elif s_lines.startswith('# down:'):
    # parse for number between <B> and </B>
    s_lines = s_lines.lstrip('<B>')
    s_lines = s_lines.rstrip('</z')
    i_down = int(s_lines)
 
FILE.close()
FILE = open(s_SummaryFile,"a")
FILE.write("\nTotal # Configured: ")
FILE.write(str(i_configured))
FILE.write("\nTotal # Down: ")
FILE.write(str(i_down))
FILE.write("\nTotal # Reporting: ")
FILE.write(str(i_configured-i_down))
FILE.close()
 

[bvdet]

Hello,

I'm running into an odd problem - well, at least I think it's odd, but that's probably because I have a Cygwin screen burned into my retinas from staring at it for so long. When I run my script below, the output lines print twice. I'm hoping it's something simple (and yet kind of not, because then I look like a fool... oh well), but hopefully a fresh pair of eyes might be able to help me.

Oh, and please feel free to comment on how I'm removing the data - I found a QAD way, but I'm guessing there might be a better way.

s_fileToParse = "/opt/www/status.html"
s_SummaryFile = "/home/user/weeklyReport.txt"
l_linesToRead = []
i_configured = 0
i_down = 0
FILE = open(s_fileToParse,"r")
 
l_linesToRead = FILE.readlines()
 
for s_lines in l_linesToRead:
  if s_lines.startswith("Total"):
    # parse for number between <B> and </B>
    s_lines = s_lines.lstrip("Total # Configured: <B>")
    s_lines = s_lines.rstrip("</B><BR>\n")
    i_configured = int(s_lines)
  elif s_lines.startswith('# down:'):
    # parse for number between <B> and </B>
    s_lines = s_lines.lstrip('<B>')
    s_lines = s_lines.rstrip('</z')
    i_down = int(s_lines)
 
FILE.close()
FILE = open(s_SummaryFile,"a")
FILE.write("\nTotal # Configured: ")
FILE.write(str(i_configured))
FILE.write("\nTotal # Down: ")
FILE.write(str(i_down))
FILE.write("\nTotal # Reporting: ")
FILE.write(str(i_configured-i_down))
FILE.close()
 

I don't see how it works at all.

elif s_lines.startswith('# down:'):
    # parse for number between <B> and </B>
    s_lines = s_lines.lstrip('<B>')
    s_lines = s_lines.rstrip('</z')
    i_down = int(s_lines)

If 's_lines.startswith('# down')' is True, s_lines.lstrip('<B>') would not do anything since '#' is the leading character. The sunsequent call to 'int()' would then fail because of the non-numeric characters. Following is a possible solution using the re module.

import re
 
fn_read = "input.txt"
fn_write = "output.txt"
patt = re.compile(r'<B>\s*(\d+)\s+</B>')
 
'''Example strings:
"Total # Configured: <B> 12345 </B><BR>\n"
"# down: <B> 67890 </B>"
'''
 
f = open(fn_read)
for line in f:
    if line.startswith('Total'):
        i_configured = int(patt.search(line).group(1))
    elif line.startswith('# down:'):
        i_down = int(patt.search(line).group(1))
 
f.close()
 
f = open(fn_write, 'a')
f.write("\nTotal # Configured: %d\nTotal # Down: %d\nTotal # Reporting: %d" % \
        (i_configured, i_down, i_configured-i_down))
f.close()

[Colloid Snake]

import re
 
fn_read = "input.txt"
fn_write = "output.txt"
patt = re.compile(r'<B>\s*(\d+)\s+</B>')
 
'''Example strings:
"Total # Configured: <B> 12345 </B><BR>\n"
"# down: <B> 67890 </B>"
'''
 
f = open(fn_read)
for line in f:
    if line.startswith('Total'):
        i_configured = int(patt.search(line).group(1))
    elif line.startswith('# down:'):
        i_down = int(patt.search(line).group(1))
 
f.close()
 
f = open(fn_write, 'a')
f.write("\nTotal # Configured: %d\nTotal # Down: %d\nTotal # Reporting: %d" % \
        (i_configured, i_down, i_configured-i_down))
f.close()

Ah, much more elegant. I wasn't sure if a regex was a good choice here, but thank you very much for the help - works like a charm!

[bvdet]

Ah, much more elegant. I wasn't sure if a regex was a good choice here, but thank you very much for the help - works like a charm!

Thanks for the feedback and you are welcome. If there is another way besides regex, you should probably try it. Regex seems to be the easiest in this case however.

[ghostdog74]

without regexp, you can just use simple string methods, eg index?

>>> s = """Total # Configured: <B> 12345 </B><BR> """
>>> s.index("<B>")
20
>>> s.index("</B>")
30
>>> s[20:30]
'<B> 12345 '
>>> s[20+4:30]
'12345 '
>>> s[20+len("<B>"):30]
' 12345 '
 
 

[bvdet]

without regexp, you can just use simple string methods, eg index?

>>> s = """Total # Configured: <B> 12345 </B><BR> """
>>> s.index("<B>")
20
>>> s.index("</B>")
30
>>> s[20:30]
'<B> 12345 '
>>> s[20+4:30]
'12345 '
>>> s[20+len("<B>"):30]
' 12345 '
 
 

It's nice to "see" you again ghostdog74. This is a good alternative to a regex solution.

[ghostdog74]

It's nice to "see" you again ghostdog74. This is a good alternative to a regex solution.

hey bv. nice to see you are still here and active as ever. :)