How to add a particular column alone in a file Post: 302327013

Sponsored Content

Top Forums Shell Programming and Scripting How to add a particular column alone in a file Post 302327013 by cutechaps on Friday 19th of June 2009 10:52:16 AM

06-19-2009

Registered User

How to add a particular column alone in a file

Hi

I have file which contains 5 coulmns i need to add the fifth column value and put it in the desired location in the same column.

Here is the sample file..

ashop0004 SQL- 06/14/2009 06/14/2009 00:04:28 SUM
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:37 928
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:32 4768
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:39 1376
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:33 672
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 SUM
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 544
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 544
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 1056
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 1056
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 SUM
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 1056
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 1056
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 SUM
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 1056
ashop0004 SQL- 06/14/2009 06/14/2009 00:00:43 544

I want to add the entries below variable SUM and put result in that place of SUM.

The file contains more then 1000 line in this format.

Can some one help me creating a script for it.

Thanks in advance

cutechaps

View Public Profile for cutechaps

Find all posts by cutechaps

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to add a new column in an existing file

Hi guys, Please help me if u have some solution. I have a file with three columns separated by ':' - INPUT_FILE C416722_2 : calin Dirigent : Dirigent AC4174_6 : Jac : cal_co TC4260_5 : [no : lin kite BC426302_1 : [no : calin Dirigent lin JC426540_3 : lin Pymo_bin : calin TC428_3 : no7...

2. Shell Programming and Scripting

Need to add letters to a column and add in a new column subtracting from another column

So I have this input 1 10327 rs112750067 T C . PASS DP=65;AF=0.208;CB=BC,NCBI 1 10469 rs117577454 C G . PASS DP=2055;AF=0.020;CB=UM,BC,NCBI 1 10492 rs55998931 C T . PASS DP=231;AF=0.167;CB=BC,NCBI 1 10583 rs58108140 G A ...

3. Shell Programming and Scripting

Add column to a file

Hola, How can I add a column to a existing file?? PS: The column which should be added need to be the first column and it will be a parameter from the script. Example: 1 name1 2 name2 3 name3 4 name3 Need to add parameter $file as a first column. $file is a file name with time...

4. Shell Programming and Scripting

Add column info from one file to larger second file

Hi, long time reader, first time poster. I've done some searching so please if this is a repeated post excuse the duplicate, but what I have are two files roughly like so: File 1: A W B X C Y D Z File 2: A 1 C 2 D 3 And what I would like to get out is...

5. Shell Programming and Scripting

How to add a column from other file?

Dear all, Lets say, I've a file a.txt containing two columns, like a1 b1 .. .. .. .. and another file b.txt containg two columns, like a1 c1 .. .. .. .. I need to put c1 column from b.txt file to the a.txt file. So, the output should be a1 b1 c1 .. .. .. .. ...

6. Shell Programming and Scripting

Help with add existing file name as new data column in new output file

Input File 1 cat S1.txt MI0043 2731 miR-1 Input File 2 cat S4.txt MI006 310 CiR-1 MI057 10 CiR-24 MI750 5 CiR-24 Desired Output File 1 cat S1.txt.out MI0043 2731 miR-1 S1.txt Desired Output File 2 cat S4.txt.out MI006 310 CiR-1 S4.txt

7. Shell Programming and Scripting

Add a new column to file

I have file like this b,c 10,20 30,40 50,60 Now I want to add a new column a with fixed values for all the rows a,b,c 60,10,20 60,30,40 60,50,60 Please let me know how can we do this in unix.

8. UNIX for Dummies Questions & Answers

Add a column to a file

Hi, I have this data file that contains: 1 A 2 B 3 C 4 D 5 E 6 F 7 G 8 H 9 I I want the results to be: 1 A A 2 B A 3 C A 4 D A 5 E A 6 F A 7 G A 8 H A

9. Shell Programming and Scripting

Add new column in the file

Hi Team I have file as below empno,ename,sal 123,smith,1000 124,adams,2000 Required output: Using AWK empno,ename,sal,deptno 123,smith,1000 124,adams,2000 Thanks, Murali

10. UNIX for Beginners Questions & Answers

Add new column from another file

Hi, I have 2 files. file1 contains by lines: hash:salt:id file2 contains by lines: username:hash:salt I would like to add a new coloumn (id) form file1 to file2. The new file should contains: username:hash:salt:id Note: file1 contains less rows than file2. I tried paste -d':' file1...

LEARN ABOUT DEBIAN

rec2csv

REC2CSV(1)							   User Commands							REC2CSV(1)

NAME

       rec2csv - rec to csv converter

SYNOPSIS

       rec2csv [OPTIONS]... [REC_FILE]

DESCRIPTION

       Convert rec data into csv data.

       -t, --type=TYPE
	      record set to convert to csv; if this parameter is omitted then the default record set is used

       -S, --sort=FIELD
	      sort the output by the specified field.

       --help print a help message and exit.

       --version
	      show version and exit.

AUTHOR

       Written by Jose E. Marchesi.

REPORTING BUGS

       Report bugs to: bug-recutils@gnu.org
       GNU recutils home page: <http://www.gnu.org/software/recutils/>
       General help using GNU software: <http://www.gnu.org/gethelp/>

COPYRIGHT

       Copyright (C) 2010, 2011, 2012 Jose E. Marchesi.  License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
       This is free software: you are free to change and redistribute it.  There is NO WARRANTY, to the extent permitted by law.

SEE ALSO

       The  full  documentation  for  rec2csv  is maintained as a Texinfo manual.  If the info and rec2csv programs are properly installed at your
       site, the command

	      info rec2csv

       should give you access to the complete manual.

rec2csv 1.4.93							   January 2012 							REC2CSV(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to add a new column in an existing file

Discussion started by: sam_2921

2. Shell Programming and Scripting

Need to add letters to a column and add in a new column subtracting from another column

Discussion started by: kellywilliams

3. Shell Programming and Scripting

Add column to a file

Discussion started by: Olivia

4. Shell Programming and Scripting

Add column info from one file to larger second file

Discussion started by: wallysb01