Breaking News: Grepper is joining You.com. Read the official announcement!

Search CSV files for text

Courageous Camel answered on June 21, 2022 Popularity 4/10 Helpfulness 1/10

answer Search CSV files for text

Search CSV files for text

Comment

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
import csv, os, glob
#input keywords to  search
keywords = ('113006249')
 
path = r'F:\Attachments\*.csv'
 
for Tname in glob.glob(path):
     
    #read csv, and split on "," the line
    csv_file = csv.reader(open(Tname, "r", encoding='utf-8'), delimiter=",")
 
    #loop through the csv list
    for row in csv_file:
        with open(r'F:\Attachments\Results\results.txt', 'w') as f:
            if keywords == row[0]:
            # print(row)  If i just print the results out to the console, i get what i need
            # print (os.path.basename(Tname))  If i just print the results out to the console, i get what i need
 
 
                f.write(' '.join(row))  but when i try to write the results to a file, i dont get anything
                #f.write(os.path.basename(Tname))  this is also something i need in the file so we know what attachment the number was found in

Popularity 4/10 Helpfulness 1/10 Language html

Source: python-forum.io

Tags: csv html search text

Link to this answer
Share Copy Link

Contributed on Jun 21 2022

Courageous Camel

0 Answers Avg Quality 2/10

Search CSV files for text

Contents

More Related Answers

Search CSV files for text

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.