Link to home
Create AccountLog in
Avatar of faithless1
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
ASKER CERTIFIED SOLUTION
Avatar of ozo
ozo
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Avatar of faithless1
faithless1

ASKER

Thanks,

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