merging files using awk Post: 302595615

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging files with AWK filtering and counting lines

Hi there, I have a couple of files I need to merge. I can do a simple merge by concatenating them into one larger file. But then I need to filter the file to get a desired result. The output looks like this: TRNH 0000000010941 ORDH OADR OADR ORDL ENDT 1116399 000000003...

2. Shell Programming and Scripting

merging of 2 files AWK - part 2

i have try , but i think i will never learn awk :( now i have 2 files : a 1:aaa:2:aaa1 2:bbb:2:bbb1 3:ccc:3:ccc1 b aaa:2 bbb:0 ccc:3 output: for all lines where a.$2 == b.$1 i want to compare a.$3 != b.$2 if true then set err=1 if false set err=0 and print all lines from file a +...

3. Shell Programming and Scripting

merging of 2 files AWK, SHELL or something else

I have 2 files pipe delimted and want to merge them based on a key e.g file 1 123|xxx|yyy|zzz 345|xab|yzy|zyz 456|sss|ttt|foo file 2 123|hhh|ggg|xxx 345|ddd|www|ddd|fff 456|ddd|sss|sss|eee so if the key is the first field, and the result should be file 1 with field 2 from file 2...

4. Shell Programming and Scripting

awk merging files based on 2 complex conditions

1. if the 1st row IDs of input1 (ID1/ID2.....) is equal to any IDNames of input2 print all relevant values together as defined in the output. 2. A bit tricky part is IDno in the output. All we need to do is numbering same kind of letters as 1 (aa of ID1) and different letters as 2 (ab...

5. Shell Programming and Scripting

awk command : row by row merging of two files

I want to write a scrpit to merge files row wise (actually concatinating) main.txt X Y Z file 1 A B C file 2 1 2 3 now i want the script to check if the file1 is empty or not, if empty then make it like A B C 1 2 3 again to check if second file is empty if not do as done...

6. Shell Programming and Scripting

AWK Script For Merging Text Files

Hello, I am trying to merge data from two text files. One file (File1) contains a listing of data which includes the trial number in Column 5, while the other text file (File2) contains what category the trial belongs to. Here is a snippet of what File1 looks like. 1 Arrow_ST 9.738 0.905...

7. Shell Programming and Scripting

Merging together two awk scripts

I have two awk scripts shown below. checkTrvt.awk works on file format .xt, whereas checkData.awk workds on file format .dat I want to merge the two scripts together, if I find that the user passed .xt file I do the code for .xt file, whereas if user passes .dat file, I go through the code for...

8. Shell Programming and Scripting

Merging two files in awk

Hi, How I can merge two file columns such as the followings using awk: file 1 2 3 2 2 1 1 file 2 4 3 4 5 7 6 Result: 2 3 4 3 2 2 4 5 1 1 7 6 This is an example, at the end, I will have about 25 files that I want to merge them, it is important for me that the order in the...

9. Shell Programming and Scripting

Merging rows in awk

Hello, I have a data format as follows: Ind1 0 1 2 Ind1 0 2 1 Ind2 1 1 0 Ind2 2 2 0 I want to use AWK to have this output: Ind1 00 12 21 Ind2 12 12 00 That is to merge each two rows with the same row names. Thank you very much in advance for your help.

10. Shell Programming and Scripting

awk Merging multiple files with symbol representing new file

I just tried following ls *.dat|sort -t"_" -k2n,2|while read f1 && read f2; do awk '{print}' $f1 awk FNR==1'{print $1,$2,$3,$4,$5,"*","*","*" }' OFS="\t" $f2 awk '{print}' $f2 donegot following result 18-Dec-1983 11:45:00 AM 18.692 84.672 0 25.4 24 18-Dec-1983 ...

LEARN ABOUT OPENSOLARIS

scsi_arq_status

scsi_arq_status(9S)					    Data Structures for Drivers 				       scsi_arq_status(9S)

NAME

       scsi_arq_status - SCSI auto request sense structure

SYNOPSIS

       #include <sys/scsi/scsi.h>

INTERFACE LEVEL

       Solaris DDI specific (Solaris DDI)

DESCRIPTION

       When auto request sense has been enabled using  scsi_ifsetcap(9F) and the "auto-rqsense" capability, the target driver must allocate a sta-
       tus area in the SCSI packet structure for the auto request sense structure (see scsi_pkt(9S)).  In the event  of  a  check  condition,  the
       transport  layer  automatically executes a request sense command.  This check ensures that the request sense information does not get lost.
       The auto request sense structure supplies the SCSI status of the original command, the transport  information  pertaining  to  the  request
       sense command, and the request sense data.

STRUCTURE MEMBERS

	 struct scsi_status	  sts_status;	       /* SCSI status */
	 struct scsi_status	  sts_rqpkt_status;    /* SCSI status of
							  request sense cmd */
	 uchar_t		  sts_rqpkt_reason;    /* reason completion */
	 uchar_t		  sts_rqpkt_resid;     /* residue */
	 uint_t 		  sts_rqpkt_state;     /* state of command */
	 uint_t 		  sts_rqpkt_statistics;/* statistics */
	 struct scsi_extended_sense sts_sensedata;	/* actual sense data */

       sts_status  is the SCSI status of the original command. If the status indicates a check condition, the transport layer might have performed
       an auto request sense command.

       sts_rqpkt_status is the SCSI status of the request sense command. sts_rqpkt_reason is the completion reason of the request  sense  command.
       If the reason is not CMD_CMPLT, then the request sense command did not complete normally.

       sts_rqpkt_resid	is the residual count of the data transfer and indicates the number of data bytes that have not been transferred. The auto
       request sense command requests SENSE_LENGTH bytes.

       sts_rqpkt_state has bit positions representing the five most important statuses that a  SCSI command can go obtain.

       sts_rqpkt_statistics maintains transport-related statistics of the request sense command.

       sts_sensedata contains the actual sense data if the request sense command completed normally.

SEE ALSO

       scsi_ifgetcap(9F), scsi_init_pkt(9F), scsi_extended_sense(9S), scsi_pkt(9S)

       Writing Device Drivers

SunOS 5.11							    30 Sep 1996 					       scsi_arq_status(9S)