Computing.Net > Forums > Unix > Merging two files by matching patial field

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Merging two files by matching patial field

Reply to Message Icon

Name: shariramani
Date: September 22, 2009 at 05:45:31 Pacific
OS: Windows XP
Subcategory: Software Problems
Comment:

Hi All,

I have two files.
cat numbers.csv
9999500123,A,B,CFGGH
01199234984,S,D,CFGde
0023445875554,sddf,fhh,wwr

cat prefix.csv
9999,jpr,3.12,60
01199234,dlr,3.23,60
00234458,uee.5,40
002344,upp,8,90

I want output as

9999,jpr,3.12,60,9999500123,A,B,CFGGH
01199234,dlr,3.23,60,01199234984,S,D,CFGde
00234458,uee.5,40,0023445875554,sddf,fhh,wwr

Pls help in unix shell script like awk. The numbers.csv is very big file.



Sponsored Link
Ads by Google

Response Number 1
Name: thepubba1
Date: September 22, 2009 at 20:49:35 Pacific
Reply:

Solution deleted. Misread the problem.


0
Reply to Message Icon

Related Posts

See More






Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Merging two files by matching patial field

trouble merging two files with awk www.computing.net/answers/unix/trouble-merging-two-files-with-awk/7937.html

Merging two files in Specific Manner www.computing.net/answers/unix/merging-two-files-in-specific-manner/8451.html

Merging two data files www.computing.net/answers/unix/merging-two-data-files/7293.html