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 DEBIAN

xjack

xjack(6x)							XScreenSaver manual							 xjack(6x)

NAME

       xjack - all work and no play makes jack a dull boy

SYNOPSIS

       xjack [-display host:display.screen] [-foreground color] [-background color] [-window] [-root] [-delay usecs] [-fps]

DESCRIPTION

       All  work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All
       work and no play makes jack a dull boy.	All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

	       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes  jack  a  dull
	       boy.   All  work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a
	       dull boy.

	       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes  jack  a  dull
	       boy.   All  work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a
	       dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.   All
       work and no play makes jack a dull boy.	All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.  All work
       and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

ENVIRONMENT

       DISPLAY All work and no play makes jack a dull boy.

       XENVIRONMENT
	       All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.

SEE ALSO

       X(1), xscreensaver(1)

COPYRIGHT

       Copyright (C) 1997 by Jamie Zawinski.  All work and no play makes jack a dull boy.  All work and no play makes jack a dull boy.	 All  work
       and  no	play  makes  jack a dull boy.  All work and no play makes jack a dull boy.  All work and no play makes jack a fnord dull boy.  All
       work and no play makes jack a dull boy.

AUTHOR

       Jamie Zawinski <jwz@jwz.org>, 15-Nov-97.

X Version 11							5.15 (28-Sep-2011)							 xjack(6x)
All times are GMT -4. The time now is 08:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy