Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: UNIX shell script for matrix insertion into a file
Top Forums UNIX for Beginners Questions & Answers UNIX shell script for matrix insertion into a file Post 303042127 by Chubler_XL on Monday 16th of December 2019 12:39:25 AM
Old 12-16-2019
You could you an awk script like this:

Code:
awk -F$'\t' '
 NR>1 {
   H=H OFS $2
   V=$3
   $0=$1
   $NR=V
   L[NR] = $0
 }
 END {
   print "Date_Time" H
   for(i=2; i in L; i++) print L[i]
 }' OFS=$'\t' infile

Last edited by Chubler_XL; 12-16-2019 at 01:58 AM.. Reason: Assuming input and output files are TAB separated
This User Gave Thanks to Chubler_XL For This Post:
RudiC
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix file operations(shell script)

Hi, I want to compare two files. Files will look like as follows: file1: ASDFGHJU|1234567890123456 QWERTYUI|3456789098900890 file2: ZXCVBVNM|0987654321234567 POLKIJUYH|1234789060985478 output file should be: ASDFGHJU|1234567890123456 QWERTYUI|3456789098900890 Thnaks in advance (6 Replies)
Discussion started by: nivas
6 Replies

2. Shell Programming and Scripting

Is it possible to draw table/matrix using shell script?

Hi all, I need to create a matrix of variable rows and columns. Right now i have 3 rows and two columns and following values. Output something like TypeA TypeB TestCase1 Pass Fail TestCase2 Pass ... (2 Replies)
Discussion started by: jakSun8
2 Replies

3. Shell Programming and Scripting

(Urgent):Creating flat file using sql script and sqlplus from UNIX Shell Script

Hi, I need help urgently for following issue. Pls help me to resolve this issue. I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql) I given... (6 Replies)
Discussion started by: praka
6 Replies

4. Shell Programming and Scripting

insertion of text from sed script

Hi , This is my first thread ; facing some issues withmy sed script I need to insert the code from my log file which is between two keywords. content is like this ........ log ############################ log1 log2 231 "Ban" "tom" and the line one of the cross line friend... (2 Replies)
Discussion started by: shalini_008
2 Replies

5. Shell Programming and Scripting

Insertion in a file

Hi All, I want to insert a line just befor the lst line in a file. please can anyone advise. Cheers, Shazin (3 Replies)
Discussion started by: Shazin
3 Replies

6. Shell Programming and Scripting

Execute unix shell script to text file using the script

Hi all, I am beginner in UNIX...I want to use unix shell script to create text.file...I know how to use using by command...can anybody tell me for the script? Thanks i changed the threads title from "tex file" to "text file", because "tex" would probably be misunderstood as reference to... (4 Replies)
Discussion started by: mastercar
4 Replies

7. Shell Programming and Scripting

AWK script problem insertion of code

Hi , I am having two files like this FILE1 #################### input SI_TESTONLY_R_00; input CE0_SE_INPUT_TESTONLY; input CE0_TCLK_TESTONLY; input SI_JTGCLOCKDR_JTAG_R_00; input CE0_TCLK_JTGCLOCKDR_JTAG; input CE0_SE_INPUT_JTGCLOCKDR_JTAG; output SO_TESTONLY_R_00; output... (2 Replies)
Discussion started by: jaita
2 Replies

8. Shell Programming and Scripting

UNIX Shell script to work with .xml file

Hi Team, Could you please help me on below query: I want to retrieve XML elements from one .xml file. This .xml file has commented tags as well. so i am planning to write Unix command/script which 1.will chekc for this .xml file 2. it will ignore the commented XML lines. i.e. XML tags between... (3 Replies)
Discussion started by: waiting4u
3 Replies

9. Shell Programming and Scripting

UNIX shell script to search a string in a file

Hi folks, I am new for shell script, I hope somebody to help me to write shell script My requirement is below steps 1. I have apache access.log i.e located in /var/log/httpd/ Ex. 127.0.0.1 - - "GET... (14 Replies)
Discussion started by: Chenchireddy
14 Replies

10. UNIX for Beginners Questions & Answers

Shell script to Split matrix file with delimiter into multiple files

I have a large semicolon delimited file with thousands of columns and many thousands of line. It looks like: ID1;ID2;ID3;ID4;A_1;B_1;C_1;A_2;B_2;C_2;A_3;B_3;C_3 AA;ax;ay;az;01;02;03;04;05;06;07;08;09 BB;bx;by;bz;03;05;33;44;15;26;27;08;09 I want to split this table in to multiple files: ... (1 Reply)
Discussion started by: trymega
1 Replies

LEARN ABOUT DEBIAN

nqs2pbs

nqs2pbs(1B)								PBS							       nqs2pbs(1B)

NAME

       nqs2pbs - convert NQS job scripts to PBS

SYNOPSIS

       nqs2pbs nqs_script [pbs_script]

DESCRIPTION

       This  utility  converts	a  existing NQS job script to work with PBS and NQS.  The existing script is copied and PBS directives, #PBS , are
       inserted prior to each NQS directive #QSUB or #@$ , in the original script.

       Certain NQS date specification and options are not supported by PBS.  A warning message will be displayed indicating the  problem  and  the
       line of the script on which it occurred.

       If  any	unrecognizable	NQS  directives  are encountered, an error message is displayed.  The new PBS script will be deleted if any errors
       occur.

OPERANDS

       nqs_script
	      Specifies the file name of the NQS script to convert.  This file is not changed.

       pbs_script
	      If specified, it is the name of the new PBS script.   If not specified, the new file name is nqs_script.new .

NOTES

       Converting NQS date specifications to the PBS form may result in a warning message and an incompleted converted date.  PBS does not support
       date  specifications  of  "today",  "tomorrow", or the name of the days of the week such as "Monday".  If any of these are encountered in a
       script, the PBS specification will contain only the time portion of the NQS specification, i.e. #PBS -a hhmm[.ss].   It is  suggested  that
       you specify the execution time on the qsub command line rather than in the script.

       Note that PBS will interpret a time specification without a date in the following way:

       -  If the time specified has not yet been reached, the job will become eligible to run at that time today.

       -  If the specified time has already passed when the job is submitted, the job will become eligible to run at that time tomorrow.

       PBS does not support time zone identifiers.  All times are taken as local time.

SEE ALSO

       qsub(1B)

Local																       nqs2pbs(1B)
All times are GMT -4. The time now is 09:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy