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.

Expand|Select|Wrap|Line Numbers

 
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.

Expand|Select|Wrap|Line Numbers

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 and 

 s_lines = s_lines.lstrip("Total # Configured: ")

 s_lines = s_lines.rstrip(" \n")

 i_configured = int(s_lines)

 elif s_lines.startswith('# down:'):

 # parse for number between and 

 s_lines = s_lines.lstrip('')

 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.

Expand|Select|Wrap|Line Numbers

 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('') 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.

Expand|Select|Wrap|Line Numbers

 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

Expand|Select|Wrap|Line Numbers

import re

fn_read = "input.txt"

fn_write = "output.txt"

patt = re.compile(r'\s*(\d+)\s+')

'''Example strings:

"Total # Configured: 12345 \n"

"# down: 67890 "

'''

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?

Expand|Select|Wrap|Line Numbers

 
>>> 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?

Expand|Select|Wrap|Line Numbers

>>> s = """Total # Configured: 12345 """

>>> s.index("")

20

>>> s.index("")

30

>>> s[20:30]

' 12345 '

>>> s[20+4:30]

'12345 '

>>> s[20+len(""):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. :)

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

Post your reply

Similar topics