How to match strings in csv file to strings in log files? Is it possible?

Question

I've been searching stackoverflow, and I can't find anyone comparing strings to log files.Is it possible to match the strings in the first column of csv file to a log file?

when it match: print true in the third column

otherwise: print undetected

for example:

             heading1                        heading2               heading3
5bfa1989e2f6e4a6af9ff62930f462e6b8632212     blablabla                true
56ef50c4b83c17e03400d129de99869d8ab18c94     blablabla              undetected

Assuming my log file has scrambled text like this:

1537763092  0   1   1   1537734291  1537734291  1537734291  8224    93  364544  5bfa1989e2f6e4a6af9ff62930f462e6b8632212.blabla Troj.Win32.TRX.XXPE50FFF026 c:\users\administrator\desktop\downloader\download\     TRENDX  172.20.4.179    Administrator   QllZad  2.0.0.0 5bfa1989e2f6e4a6af9ff62930f462e6b8632212        AAAAAAAAAAQAIQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=

It is possible - your log file is just a white space separated file and you could turn that into a csv file easily enough if that helps (or not). What code have you tried already? What makes you think it's not possible, or what problems have you already encountered? — Pam
– Pam, Commented Oct 2, 2018 at 10:37
because I'm given a task to match my csv file to lof file, that's why — Godshand
– Godshand, Commented Oct 2, 2018 at 10:40
what you're saying is that I should convert the log file into a csv? — Godshand
– Godshand, Commented Oct 2, 2018 at 10:41
You need one of these. Either you'll solve your own problem in creating it, or people will be better able to help you. If you have code that you've tried, tidy it up (if it needs it) and post it. — Pam
– Pam, Commented Oct 2, 2018 at 13:20

tank1610 · Accepted Answer · 2018-10-02 10:43:30Z

1

Yes, it is possible. Something like this worked for me:

import csv

logfile = open('test_log.log', 'r') 
log = logfile.read().split(" ") #Read the log file and split on space

with open('data.csv','r') as csvfile:
    reader = csv.reader(csvfile)
    for line in reader:
        if line[0] in log:
            print(line[0])

Note that if you want to write back to the csv, you need to read the whole csv, make changes, then write to file.

answered Oct 2, 2018 at 10:43

tank1610

492 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Godshand Over a year ago

tried this, but didn't worked pastebin.com/0Yc6JVs5 take a look at this, my log file

tank1610 Over a year ago

What did you try and did you get out? This code is just an example to show how you can match a field in the csv file to a string in the log file.

Collectives™ on Stack Overflow

How to match strings in csv file to strings in log files? Is it possible?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related