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
Perl

Avatar of undefined
Last Comment
faithless1

8/22/2022 - Mon