awk-adding a column to a file Post: 302348178

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

FILE:Adding new column

Is it possible to add a new column in a file by matching a key element in second file ? File 1 2 a 3 b 4 d 5 g 6 j 7 m File 2 4 hjjjj 5 aaa 6 sasa 7 dsds 2 dsdf 3 fdsfg

2. Shell Programming and Scripting

problem while adding column values in awk

Hi, I have a file "input.txt" with the following content : 5312,0,,,1,8,141.2,20090727 3714,0,,,1,8,285.87,20090727 5426,0,,,1,8,3.9,20090727 3871,0,,,1,8,30.4,20090727 9071,0,,,1,8,146.2,20090727 5141,0,,,1,8,2.8,20090727 0460,0,,,1,8,-0.1,20090727 7918,0,,,1,8,-0.1,20090727...

3. Shell Programming and Scripting

sed/awk-adding numeric to a column

I have a txt file as follows Code: Oct 1 file1 4144 Oct 1 file23 5170 Oct 2 file5 3434 Oct 21 file56 2343 I need to add a new column by marking the right log file from current directory. For example populate like this. Please not in the second columt for "1" it has...

4. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Is there anyway to use awk to add a first column to my data that automatically goes from 1 to n , where n is the numbers of my rows?:confused:

5. Shell Programming and Scripting

Adding column using awk

Hello everyone, I have a file with the following structure: abc xyz 111 222 agf hjhf 787 799 tht yah 878 898 ... ... ... ... ... ... ... ... ... ... ... ... I want to add a column (with a fixed value of 1000) at the end such that it becomes: abc xyz 111 222 1000 agf hjhf 787...

6. Linux

Adding a prefix to a column using awk/sed commands

Hello, I am a newbie to linux and struggling to find a better way to append a column in a text file. Here is the file i want to modify: It has 8 columns (and thousands of rows). I want to append the first column by adding "chr" infront of the numbers. Some rows have a string in the first...

7. Shell Programming and Scripting

Adding a column to a file

Hello all, I need to add a coloumn at the 5th Position of a file, Can this be done using awk or sed. Sample Input 1008,300186,R,2009,0,2,2,3,2,0,1,1,1,1,2,1,1,0,2,1,1,0,2,2,2,2,0,0,0,0,1,0,2,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0,0,0,3,2,3,1,1,1, Ouput: ...

8. Shell Programming and Scripting

Adding a specified value to a specified column - awk?

Hi everyone! I sometimes need to do some simple arithmetics, like adding a number to a certain column of a file. So I wrote a small function in the .bashrc file, which looks like this shifter() { COL=$1 VAL=$2 FILE=$3 cp $FILE $FILE.shifted awk 'NF==4 {$(( $COL )) = $(( $COL ))...

9. UNIX for Dummies Questions & Answers

awk adding counts together from column

Hello Im new treat me nicely, I have a headache :) I have a script that seemed to work now it doesnt anyway, the last part is adding counts of unique items in a csv file eg 05492U34 38 05492U34 47 two columns, (many different values like this in file) i want...

10. UNIX for Dummies Questions & Answers

Des/awk for change format and adding integers in a column of data?

Greetings! I need a quick way to change the format in a table of data Here is an example of the input: 10 72 Value=177 VDB=0.0245 Value4=0,0,171,0 10 274 Value=238 VDB=0.0433 Value4=29,0,205,0 10 312 Value=222 VDB=0.0384 Value4=8,0,190,19 10 540 Value=405 VDB=0.0391 Value4=13,30,153,195...

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)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

FILE:Adding new column

Discussion started by: sandeep_hi

2. Shell Programming and Scripting

problem while adding column values in awk

Discussion started by: valokv

3. Shell Programming and Scripting

sed/awk-adding numeric to a column

Discussion started by: gubbu

4. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Discussion started by: cosmologist