Search Results

Search: Posts Made By: bkane3
1,309
Posted By bkane3
awk pattern match not printing desired columns
Hi all, I'm trying to match the following two files with the code below:


awk -F, 'NR==FNR {a[$1,$2]=$0; next} ($12,$4) in a {print $12,$1,a[$1,$2]}' OFS="," file4.csv file3.csv


but the code...
7,614
Posted By bkane3
Thanks this works with the following examples...
Thanks this works with the following examples files. However, it's been 4 hours since I've started running on the actual files I have, and it still has not finished. The actual file3 I have is about...
7,614
Posted By bkane3
Thank you Akshay. That worked. I have...
Thank you Akshay. That worked.

I have another similar matching problem. I want to compare the previous outputted result file (I will call it file3) with file4 (below) by...
7,614
Posted By bkane3
Compare 2 csv files by columns, then extract certain columns of matcing rows
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.

I...
Showing results 1 to 4 of 4

 
All times are GMT -4. The time now is 08:32 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy