Hi,
I have two CSVs, the CSVs are not the same format, specifically I have a different number of columns and also the content I am searching for is in a different format.
e.g. CSV1 has a column with a filename including its physical path, the second CSV which I want to use to find all the matching files within CSV1 only has the filename.
I didn't find a way to use expersions to find where CSV2 has a filename somewhere within the semicolons, that exists in CSV1.
The files are over a few GB each, so all other tools e.g. notepad++ where I know how to do this, cannot open load such files into memory.
Can someone tell me of a way to achieve this?
I have two CSVs, the CSVs are not the same format, specifically I have a different number of columns and also the content I am searching for is in a different format.
e.g. CSV1 has a column with a filename including its physical path, the second CSV which I want to use to find all the matching files within CSV1 only has the filename.
I didn't find a way to use expersions to find where CSV2 has a filename somewhere within the semicolons, that exists in CSV1.
The files are over a few GB each, so all other tools e.g. notepad++ where I know how to do this, cannot open load such files into memory.
Can someone tell me of a way to achieve this?
Comment