Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Adding columns from 2 files with variable number of columns
Top Forums Shell Programming and Scripting Adding columns from 2 files with variable number of columns Post 303023010 by maya3 on Monday 10th of September 2018 12:24:10 PM
Old 09-10-2018
Yes it does work, sorry, I've typed i<NF/2 instead of i<=NF/2.

May I ask, what does
Code:
(i==NF/2)?ORS:OFS

mean? I assume it means that when i is equal to half of the number of records it goes into newline? How does it exactly do that?
Last edited by maya3; 09-10-2018 at 01:29 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Adding columns to excel files using Perl

How do I add 4 columns to an excel file using Perl? The 4 headers for those columns will all have different names? Please help and I greatly appreciate... (1 Reply)
Discussion started by: dolo21taf
1 Replies

2. Shell Programming and Scripting

comparing files - adding/subtracting/formating columns

I have two files: file1.txt: FS Total Used Free Used% /u01 10000 8000 2000 80% /u02 10000 8000 2000 80% /u03 10000 8000 2000 80% /u04 10000 8000 2000 80% /u05 10000 8000 2000 80% /u06 10000 8000 2000 80% /u07 10000 8000 2000 80% /u10 10000 5000 5000 50% file2.txt:... (7 Replies)
Discussion started by: oabdalla
7 Replies

3. Shell Programming and Scripting

awk adding columns from different files

Hi, I have two files and I need to add column 3 of file1 to column 3 of file 2 > file3 I also need to repeat for column 4. Thanks (1 Reply)
Discussion started by: dsstamps
1 Replies

4. Shell Programming and Scripting

Adding columns of two files

Hello everyone, I have two files containing 6 columns and thousands of rows. I want to add them (i.e. first column of first file + first column of second file and so on) and print the output in a third file. Can you please help me. Thanks a lot (7 Replies)
Discussion started by: chandra321
7 Replies

5. Shell Programming and Scripting

merging files and adding special columns

Hi everyone, I got a problem with merging files and hoped one of you would have an idea how to approach this issue. I tried it with awk, but didn't get far. This is what I have: I got 40 files looking like the ones below. All have three columns but the number of rows differs (20000 to 50000).... (6 Replies)
Discussion started by: TuAd
6 Replies

6. UNIX for Dummies Questions & Answers

Adding new columns to txt files

Dear all, I have a question. I have a txt.file as below. i want to add 3 more columns: column3=conlum 2*column2; column4=(1-column2)*(1-column2); column5=1-column3-column4. Do you know how to do it? Thanks a lot! file: column1 column2 a 1 b 20 c 30 d 3 ... (2 Replies)
Discussion started by: forevertl
2 Replies

7. Shell Programming and Scripting

Adding Multiple Files via Columns

I have a number of files with multiple rows that I need to add together. Let say I have 10 files: Each file has a great number of rows and columns. I need to add these files together the following way. In other words, If, for example, file A occupies Columns 1 to 19, I want to add file B... (7 Replies)
Discussion started by: Ernst
7 Replies

8. Shell Programming and Scripting

Adding columns with values dependent on existing columns

Hello I have a file as below chr1 start ref alt code1 code2 chr1 18884 C CAAAA 2 0 chr1 135419 TATACA T 2 0 chr1 332045 T TTG 0 2 chr1 453838 T TAC 2 0 chr1 567652 T TG 1 0 chr1 602541 ... (2 Replies)
Discussion started by: plumb_r
2 Replies

9. Shell Programming and Scripting

Adding info to end of line if two columns match from files with different separators

I have two files (csv and vcf) which look exactly like this S1.csv func,gene,start,info "exonic","AL","2309","het" "exonic","NEF","6912","hom"S1.vcf ##fileinfo #CHROM POS ID INFO chr1 4567 rs323211 1/1:84,104,99 chr4 2309 rs346742 1/1:27,213,90 chr6 5834 ... (5 Replies)
Discussion started by: Sarah_19
5 Replies

10. Shell Programming and Scripting

Request: How to Parse dynamic SQL query to pad extra columns to match the fixed number of columns

Hello All, I have a requirement in which i will be given a sql query as input in a file with dynamic number of columns. For example some times i will get 5 columns, some times 8 columns etc up to 20 columns. So my requirement is to generate a output query which will have 20 columns all the... (7 Replies)
Discussion started by: vikas_trl
7 Replies

LEARN ABOUT HPUX

dtmmdbgraphicinfo

DtMmdbGraphicInfo(file formats) 										   DtMmdbGraphicInfo(file formats)

NAME

       DtMmdbGraphicInfo -- graphic object structure in dtinfo

DESCRIPTION

       The DtMmdbGraphicInfo structure contains information about a graphic object in dtinfo.

       The DtMmdbGraphicInfo structure is defined as follows:

       #include <DtInfo/DtMmdb.h>
       typedef struct _DtMmdbGraphicInfo {
	  unsigned short coding;
	  unsigned short width;
	  unsigned short height;
	  unsigned int llx;
	  unsigned int lly;
	  unsigned int urx;
	  unsigned int ury;
	  char* version;
       } DtMmdbGraphicInfo;

       The DtMmdbGraphicInfo members have the following meanings:

       coding	 Specifies the type of the object. Valid values are:

		 DtMmdbGraphicEPS
			   Indicates an Encapsulated PostScript typed object.

		 DtMmdbGraphicGIF
			   Indicates a GIF typed object.

		 DtMmdbGraphicXPM
			   Indicates an XPM typed object.

		 DtMmdbGraphicXBM
			   Indicates an XBM typed object.

		 DtMmdbGraphicCGM
			   Indicates a CGM typed object (not supported)

		 DtMmdbGraphicJPEG
			   Indicates a JPEG typed object (not supported)

		 DtMmdbGraphicTIFF
			   Indicates a TIFF typed object (not supported)

		 DtMmdbGraphicXWD
			   Indicates an XWD typed object (not supported)

		 DtMmdbGraphicUnknown
			   Indicates an object of unknown type

       width	 Specifies the width of the object (in points).

       height	 Specifies the height of the object (in points).

       llx	 Specifies the X coordinate for the lower left corner if the object is of type Encapsulated PostScript.

       lly	 Specifies the Y coordinate for the lower left corner if the object is of type Encapsulated PostScript.

       urx	 Specifies the X coordinate for the upper right corner if the object is of type Encapsulated PostScript.

       ury	 Specifies the Y coordinate for the upper right corner if the object is of type Encapsulated PostScript.

       version	 Specifies the version of the object. Currently returns NULL. To be specified in the future.

SEE ALSO

       DtMmdbFreeGraphicInfo(3), DtMmdbGraphicGetData(3), DtMmdbGraphicGetInfo(3)

														   DtMmdbGraphicInfo(file formats)
All times are GMT -4. The time now is 03:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy