|
LQ Newbie
Registered: Jun 2008
Location: England
Posts: 21
Rep: 
|
CSV file merge help
Hi,
Although I'm not a developer, I can pick things up when spoon fed a little :-)
Here is what I'm trying to accomplish (a friend suggested BASH for this)....
I have two CSV files, a demographics file and a financial file and I wish to merge them using a unique ID.
Demographics.csv
ID, surname, first name, address 1, address 2, address 3, address 4
8761, Jones, John, 10 Street, London, , NW1 4TT
36609, Smith, Ken, 10 Road, London, , NW1 6JJ
89877, Miller, Luke, 70 Something, Harlow, Essex, ES6 8JU
8786, Riley, Kim, 67 Runway, Grantham, , GR5 7FD
5432, Kendal, Clive, 89 Street, London, NW1 4TT
Finance.csv
ID, Balance
8761, 300.00
36609, -200.00
89877, 500.00
The third file which is my desired output would look like this:-
output.csv
ID, surname, first name, address 1, address 2, address 3, address 4, balance
8761, Jones, John, 10 Street, London, , NW1 4TT, 300.00
36609, Smith, Ken, 10 Road, London, , NW1 6JJ, -200.00
89877, Miller, Luke, 70 Something, Harlow, Essex, ES6 8JU, 500.00
Where no ID is found in finance.csv, do not write output in the output.csv
How would I ideally accomplish this? Code samples would be great if possible.
Many thanks for your help.
|
