Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Matching column value from 2 different file using awk and append value from different column

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Matching column value from 2 different file using awk and append value from different column
# 8  
Old 09-17-2017
Quote:
Originally Posted by tententen
.
.
.
Is there a way to also handle double quotes?
.
.
.
WHAT? That pipe is DESIGNED to handle double quotes...


Please become accustomed to provide decent context info of your problem.
It is always helpful to carefully and detailedly phrase a request, and to support it with system info like OS and shell, related environment (variables, options), preferred tools, adequate (representative) sample input and desired output data and the logics connecting the two, and, if existent, system (error) messages verbatim, to avoid ambiguities and keep people from guessing.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies

2. Shell Programming and Scripting

awk script to append suffix to column when column has duplicated values

Please help me to get required output for both scenario 1 and scenario 2 and need separate code for both scenario 1 and scenario 2 Scenario 1 i need to do below changes only when column1 is CR and column3 has duplicates rows/values. This inputfile can contain 100 of this duplicated rows of... (1 Reply)
Discussion started by: as7951
1 Replies

3. Shell Programming and Scripting

awk to Sum columns when other column has duplicates and append one column value to another with Care

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (1 Reply)
Discussion started by: as7951
1 Replies

4. Shell Programming and Scripting

Matching column then append to existing File as new column

Good evening I have the below requirements, as I am not an experts in Linux/Unix and am looking for your ideas how I can do this. I have file called file1 and file2. I need to get the second column which is text1_random_alphabets and find that in file 2, if it's exists then print the 3rd... (4 Replies)
Discussion started by: mychbears
4 Replies

5. Shell Programming and Scripting

Solution for replacement of 4th column with 3rd column in a file using awk/sed preserving delimters

input "A","B","C,D","E","F" "S","T","U,V","W","X" "AA","BB","CC,DD","EEEE","FFF" required output: "A","B","C,D","C,D","F" "S", T","U,V","U,V","X" "AA","BB","CC,DD","CC,DD","FFF" tried using awk but double quotes not preserving for every field. any help to solve this is much... (5 Replies)
Discussion started by: khblts
5 Replies

6. Shell Programming and Scripting

How to awk or grep the last column in file when date on column contains spaces?

Hi have a large spreadsheet which has 4 columns APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96085 Corp IT Desktop and Apps APM00111803814 server_2 96034 Storage Mgmt Team APM00111803814 server_2 96152 GWP... (6 Replies)
Discussion started by: kieranfoley
6 Replies

7. Shell Programming and Scripting

Find lines with matching column 1 value, retain only the one with highest value in column 2

I have a file like: I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4. Desired output: I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

8. Shell Programming and Scripting

Append column using awk/nawk

Is there any way I can achieve this? Considering test1 : a 1 2 3 4 b 2 3 4 5 c 12 1232 14 1 d 10 13 4 5 e 1 5 6 9 1 And test to be some string : qw twe tew we qw I want something like this : a 1 2 qw 4 b 2 3 twe 5 (5 Replies)
Discussion started by: aksijain
5 Replies

9. UNIX for Dummies Questions & Answers

append column and row header to a file in awk script.

Hi! Is there a way to append column and row header to a file in awk script. For example if I have Jane F 39 manager Carlos M 40 system administrator Sam F 20 programmer and I want it to be # name gend age occup 1 Jane F 39 manager 2 Carlos M ... (4 Replies)
Discussion started by: FUTURE_EINSTEIN
4 Replies

10. Shell Programming and Scripting

Awk: Need help replacing a specific column in a file by part of a column in another file

Hi, I have two input files as File1 : ABC:client1:project1 XYZ:client2-aa:project2 DEF:client4:proj File2 : client1:W-170:xx client2-aa:WT-04:yy client4:L-005A:zz Also, array of valid values can be hardcoded like Output : ABC:W:project1 XYZ:WT:project2 (1 Reply)
Discussion started by: aa2601
1 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

fitsort

fitsort(1)						      General Commands Manual							fitsort(1)

NAME

       fitsort - sort FITS header information from a list of files

SYNOPSIS

       dfits <FITS files...> | fitsort <FITS keywords...>

DESCRIPTION

       fitsort	extract keyword values from a set of FITS headers and outputs it in an ASCII table format, which is compatible with most data pro-
       cessing software packages. It shall only be used in combination with the dfits utility.

       The ASCII output is shown in columns. Columns are aligned with blank characters and also separated by tabulations. Blank  alignment  allows
       human readers to visualize the output in a pretty format, tabulations are there for spreadsheet compatibility. If you want to load out fit-
       sort output into any spreadsheet, specify that fields shall be separated by tabulations and entries separated by linefeeds.

       Examples :
       dfits *.fits | fitsort BITPIX NAXIS NAXIS1 NAXIS2

       The output would look like:
       FILE	      BITPIX   NAXIS	NAXIS1	 NAXIS2
       file0001.fits  16       2	128	 128
       file0002.fits  32       2	512	 512
       ...

       ESO specific features in the FITS header are also supported. To get values for 'HIERARCH ESO' keywords, just give the complete names within
       double quotes. e.g.

       dfits *.fits | fitsort "HIERARCH ESO INS LENS"

       Another way of giving HIERARCH ESO keywords is to use the short FITS notation, the above example can be given as:

       dfits *.fits | fitsort INS.LENS

       Example: to retrieve the DPR keywords from an ESO FITS header, you would use:

       dfits *.fits | fitsort To be completed...  DPR.CATG DPR.TYPE DPR.TECH

       This  second way of requesting HIERARCH ESO keywords is not only shorter to type, it also avoids typing quotes or double-quotes on the com-
       mand-line, making it easier to script with fitsort.

       Notice that the keywords you give on the command-line are case-insensitive.  The above line is equivalent to:

       dfits *.fits | fitsort dpr.catg dpr.type dpr.tech

OPTIONS

       -d     Do not print out the first output line. This option is useful to get only the query results, without the top line (giving all column
	      names). This makes it easy to script fitsort from programs like awk or perl.

FILES

       Input files to dfits shall all comply with FITS format.	fitsort also supports HIERARCH ESO FITS format.

SEE ALSO

       dfits (1)

								    25 Jun 2001 							fitsort(1)