Appending different columns of multiple files in awk Post: 303005727

Sponsored Content

Top Forums Shell Programming and Scripting Appending different columns of multiple files in awk Post 303005727 by Aia on Sunday 22nd of October 2017 12:20:55 PM

10-22-2017

Registered User

Quote:

Originally Posted by looney

Code:

cat file1
col1|col2|col3
a|1|A
b|2|B

cat file2
col1|col2|col3
c|3|C

cat file3
col1|col2|col3
d|4|D
e|5|E

i want below output
file4

Code:

col1|col2
a|1
3|C
D|4

Where does the D|4 come from?
What happened to b|2|B?

---------- Post updated at 10:20 AM ---------- Previous update was at 09:52 AM ----------

Quote:

Originally Posted by looney

there is one error giving psuedo code i could write.

Code:

awk -F"|" '{ print $1,$2 }' file1 '{print $2,$3}' file2 '{print $3,$1}' file3

please help me on this..

The format of an AWK command looks as follows:

Code:

awk 'pattern {action}' input-file ...

Which means until here everything will go well:

Code:

awk -F"|" '{ print $1,$2 }' file1

The rest is not correct, unless all of them are files.

Code:

'{print $2,$3}' file2 '{print $3,$1}' file3

Quote:

Originally Posted by looney

there is no logic inside it. I am just looking a way to append different fields of different files in awk

That sounds a bit like what's the answer to the ultimate question of Life, The Universe, and Everything.

Aia

View Public Profile for Aia

Find all posts by Aia

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk 3 files to one based on multiple columns

Hi all, I have three files, one is a navigation file, one is a depth file and one is a file containing the measured field of gravity. The formats of the files are; navigation file: 2006 320 17 39 0 0 *nav 21.31542 -157.887 2006 320 17 39 10 0 *nav 21.31542 -157.887 2006 320 17 39 20 0...

2. Shell Programming and Scripting

appending several columns with awk and paste

Hello, I am trying to solve for a couple of hours now the following problem: I have n files and would like to add the third column of each file to a new file: temp1.txt 1 2 3 1 2 3 1 2 3 temp2.txt 1 2 4 1 2 4 1 2 4 1 2 4 temp3.txt

3. UNIX for Dummies Questions & Answers

Extracting columns from multiple files with awk

hi everyone! I already posted it in scripts, I'm sorry, it's doubled I'd like to extract a single column from 5 different files and put them together in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is: awk 'NR==FNR{a=$2; next}...

4. Shell Programming and Scripting

Extracting columns from multiple files with awk

hi everyone! I'd like to extract a single column from 5 different files and put them together in an output file. I saw a similar question for 2 input files, and the line of code workd very well, the code is: awk 'NR==FNR{a=$2; next} {print a, $2}' file1 file2 I added the file3, file4 and...

5. Shell Programming and Scripting

Appending columns of two files using shell script

Hi, I am using ksh, I want to read one csv file and append the columns of another file with new column. My input file: col1,col2 --------- siri,886 satya,890 priya,850 Another file with the below date:(test.csv) col3 ----- 321 333 442

6. UNIX for Dummies Questions & Answers

Appending columns at the end of output using awk/sed

Hi , I have the below ouput, =====gopi===== assasassaa adsadsadsdsada asdsadsadasdsa sadasdsadsd =====kannan=== asdasdasd sadasddsaasd adasdd =====hbk=== asasasssa .... .. I want the output like as below, not able paste here correctly.

7. Shell Programming and Scripting

awk script to split file into multiple files based on many columns

So I have a space delimited file that I'd like to split into multiple files based on multiple column values. This is what my data looks like 1bc9A02 1 10 1000 FTDLNLVQALRQFLWSFRLPGEAQKIDRMMEAFAQRYCQCNNGVFQSTDTCYVLSFAIIMLNTSLHNPNVKDKPTVERFIAMNRGINDGGDLPEELLRNLYESIKNEPFKIPELEHHHHHH 1ku1A02 1 10...

8. Shell Programming and Scripting

awk arrays comparing multiple columns across two files.

Hi, I'm trying to use awk arrays to compare values across two files based on multiple columns. I've attempted to load file 2 into an array and compare with values in file 1, but success has been absent. If anyone has any suggestions (and I'm not even sure if my script so far is on the right lines)...

9. UNIX for Dummies Questions & Answers

Appending multiple files

I am trying to append multiple files in a directory cat /a/file1.txt /a/file2.txt /a/file3.txt /a/file4.txt > /a/file.txt Except file2 every other file is appending. I interchanged file names and ran the command. Whatever file repeating in the second position is missing in output...

10. Shell Programming and Scripting

Appending multiple files through UNIX

Hi All, I have requirement where multiple csv files are present in a directory and each file contains a header.I need to append the contents of all the files into one file by removing header. Once the data is merged in one file ,I need to remove duplicates on nth column to find out distinct...

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk 3 files to one based on multiple columns

Discussion started by: andrealphus

2. Shell Programming and Scripting

appending several columns with awk and paste

Discussion started by: creamcheese

3. UNIX for Dummies Questions & Answers

Extracting columns from multiple files with awk

Discussion started by: orcaja

4. Shell Programming and Scripting

Extracting columns from multiple files with awk

Discussion started by: orcaja

5. Shell Programming and Scripting

Appending columns of two files using shell script

Discussion started by: siri_886

6. UNIX for Dummies Questions & Answers

Appending columns at the end of output using awk/sed

Discussion started by: eeegopikannan

7. Shell Programming and Scripting

awk script to split file into multiple files based on many columns

Discussion started by: viored

8. Shell Programming and Scripting

awk arrays comparing multiple columns across two files.

Discussion started by: hubleo

9. UNIX for Dummies Questions & Answers

Appending multiple files

Discussion started by: eskay

10. Shell Programming and Scripting

Appending multiple files through UNIX

Discussion started by: STCET22