Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Merge 2 csv files with awk
Top Forums Shell Programming and Scripting Merge 2 csv files with awk Post 302480591 by zaxxon on Wednesday 15th of December 2010 10:01:09 AM
Old 12-15-2010
I asume there is a typo or I misunderstood the logic. From your description the output should look like:
Code:
$> join -t\$ -1 1 -2 1 -o 1.1,2.2,1.2,1.3,1.4 f1 f2
123$hhh$xxx$yyy$zzz
345$ddd$xab$yzy$zyz
456$xxx$sss$ttt$foo

In your output example, the row starting with 345 suddenly only has 4 fields instead of 5 but I can't see by what criteria this happens. For the line starting with 456, I can't see where the rule
Quote:
so if the key is the first field, and the result should be file 1 with field 2 from file 2 based on the key
is still correct. There is suddenly ddd from the row before in it and the order doesn't seem to be correct anymore.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merge files of differrent size with one field common in both files using awk

hi, i am facing a problem in merging two files using awk, the problem is as stated below, file1: A|B|C|D|E|F|G|H|I|1 M|N|O|P|Q|R|S|T|U|2 AA|BB|CC|DD|EE|FF|GG|HH|II|1 .... .... .... file2 : 1|Mn|op|qr (2 Replies)
Discussion started by: shashi1982
2 Replies

2. Shell Programming and Scripting

Merge 2 CSV files using sed

Help in writing a script using sed which updates fileOne with the contents from fileTwo Example: Contents of fileOne 1,111111 2,897823 3,235473 4,222222 Contents of fileTwo 1,111111,A,1,2 4,222222,A,2,2 5,374632,A,3,2 6,374654,A,4,2 Final File should be: 1,111111,A,1,2... (9 Replies)
Discussion started by: NewToSed
9 Replies

3. Shell Programming and Scripting

Merge CSV files and create a column with the filename from the original file

Hello everyone!! I am not completely new to shell script but I havent been able to find the answer to my problem and I'm sure there are some smart brains here up for the challenge :D. I have several CSV files that I need to combine into one, but I also need to know where each row came from.... (7 Replies)
Discussion started by: fransanchezoria
7 Replies

4. Shell Programming and Scripting

Merge *.csv files, each in separate sheets

Does anyone know how to Merge *.csv files, each in seperate sheets? (7 Replies)
Discussion started by: frhling
7 Replies

5. UNIX for Dummies Questions & Answers

Need help combining txt files w/ multiple lines into csv single cell - also need data merge

:confused:Hello -- i just joined the forums. I am a complete noob -- only about 1 week into learning how to program anything... and starting with linux. I am working in Linux terminal. I have a folder with a bunch of txt files. Each file has several lines of html code. I want to combine... (2 Replies)
Discussion started by: jetsetter
2 Replies

6. Shell Programming and Scripting

Merge CSV files

I have lot of csv file collected from script like below : Name of files (some examples) there are thousands of it: 192.168.0.123_251_18796_1433144473.csv 192.168.0.123_251_18796_1433144772.csv 192.168.0.123_251_18796_1433145073.csv 192.168.0.123_251_18796_1433145372.csvContent of each... (5 Replies)
Discussion started by: rk4k
5 Replies

7. UNIX for Dummies Questions & Answers

Merge two csv files using column name

Hi all, I have two separate csv files(comma delimited) file 1 and file 2. File 1 contains PAN,NAME,Salary AAAAA5467D,Raj,50000 AAFAC5467D,Ram,60000 BDCFA5677D,Kumar,90000 File 2 contains PAN,NAME,Dept,Salary ASDFG6756T,Karthik,ABC,450000 QWERT8765Y,JAX,CDR,780000... (5 Replies)
Discussion started by: Nivas
5 Replies

8. Shell Programming and Scripting

I am trying to merge all csv files from source path into 1 file

I am trying to merge all csv files from source path into one single csv file in target. but getting error message: hadoop fs -cat /user/hive/warehouse/stage.db/PK_CLOUD_CHARGE/TCH-charge_*.csv > /user/hive/warehouse/stage.db/PK_CLOUD_CHARGE/final/TCH_pb_charge.csv getting error message:... (0 Replies)
Discussion started by: cplusplus1
0 Replies

9. Shell Programming and Scripting

Compare and merge two big CSV files

Hi all, i need help. I have two csv files with a huge amount of data. I need the first column of the first file, to be compared with the data of the second, to have at the end a file with the data not present in the second file. Example File1: (only one column) profile_id 57036226... (11 Replies)
Discussion started by: SirMannu
11 Replies

10. UNIX for Beginners Questions & Answers

Merge the three csv files as one according to first coloumn.

I have three files with similar pattern i need to merge all the coloumns side by side from all three files according to the first coloumn example as shown below I mentioned 5 coloumns only in example but i have around 15 coloumns in each file. file1: Name,Samples,Error,95RT,90RT... (4 Replies)
Discussion started by: Raghuram717
4 Replies

LEARN ABOUT DEBIAN

intltool-merge

INTLTOOL-MERGE(8)					      System Manager's Manual						 INTLTOOL-MERGE(8)

NAME

       intltool-merge - merge translated strings into various types of file

SYNOPSIS

       intltool-merge [option]... PO_DIRECTORY FILENAME OUTPUT_FILE

DESCRIPTION

       Merge  translated strings in po files in PO_DIRECTORY with the original application file FILENAME, and output the file OUTPUT_FILE contain-
       ing both original and localized strings.

       If FILENAME is an XML file, OUTPUT_FILE will contain repeated xml nodes, where each  node  contains  one  of  the  localized  strings  with
       "xml:lang" attribute.

OPTIONS

   Mode of operation
       -b
       --ba-style
	   Merge files in bonobo-activation style, which is used for bonobo servers.

       -d
       --desktop-style
	   Merge files in desktop style, which is similar to the Windows .ini file format.

       -k
       --keys-style
	   Merge files in keys style, which is used for metadata.

       -o
       --oaf-style
	   (OBSOLETE) Same as -b/--ba-style.

       -r
       --rfc822deb-style
	   Merge files in RFC 822 style, which is usually used in Debian configuration files.

       --quoted-style
	   Merge files in quoted string style, which just translates any strings within "".

       -x
       --xml-style
	   Merge files in standard XML style, both as attributes and as raw pcdata.

   Other options
       -u
       --utf8
	   Convert all strings to UTF-8 before merging.

       -p
       --pass-through
	   Use strings as is in .po files without conversion (STRONGLY unrecommended with -x).

       -c
       --cache
	   (TBD)

       -q
       --quiet
	   Be quiet while running.

       -v
       --version
	   Show version information.

       -h
       --help
	   Show usage and basic help information.

FILES

       po/.intltool-merge-cache
	      Cache file generated by intltool-merge, that contains all strings in all po files separated by 1.

REPORTING BUGS

       Report bugs to http://bugs.launchpad.net/intltool

AUTHOR

       Darin Adler <darin@bentspoon.com>
       Kenneth Christiansen <kenneth@gnu.org>
       Maciej Stachowiak <mjs@eazel.com>

SEE ALSO

       iconv(1), intltoolize(8), intltool-prepare(8), intltool-extract(8), intltool-update(8)

intltool							    2003-08-02							 INTLTOOL-MERGE(8)
All times are GMT -4. The time now is 08:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy