faithless1
asked on
File Manipulation
Hello,
I have a list of CSV (10+) files (i.e. A001.csv-A180), all of which contain data in column 13. I'm interested in doing the following:
1. Output a list of records from file 1 which are present in other files along with the file names where these records are found.
Example of output for file 1. (A001_recurring.csv)
best day A002.csv
best day A003.csv
etc
Example of output for file 2. (A002_recurring.csv)
best day A001.csv
best day A003.csv
etc
Join all recurring files to create a main document.
Thank you
I have a list of CSV (10+) files (i.e. A001.csv-A180), all of which contain data in column 13. I'm interested in doing the following:
1. Output a list of records from file 1 which are present in other files along with the file names where these records are found.
Example of output for file 1. (A001_recurring.csv)
best day A002.csv
best day A003.csv
etc
Example of output for file 2. (A002_recurring.csv)
best day A001.csv
best day A003.csv
etc
Join all recurring files to create a main document.
Thank you
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
The script only inserted file names into each file. Example below
cat A001.csv_recurring.csv
A002.csv
Files
cat A001.csv
store
store went
new
cat A002.csv
store
store went
new
random
Thanks