Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: how to add new col in a file
Top Forums Shell Programming and Scripting how to add new col in a file Post 302486635 by ken002 on Sunday 9th of January 2011 09:06:33 PM
Old 01-09-2011
how to add new col in a file
Hi, Experts,
I have a requirement as following:
my source file:
a
a
a
b
b
c
c
c
c
I need add one more colume as following:
1 a
2 a
3 a
1 b
2 b
1 c
2 c
3 c
4 c

anybody can help me out.

Thanks in advance
ken002
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

sum(col) finding from a file

Hi I have an file which looks like country address phone amount sweden |address |phone | 10 | Singapo |address |phone | 20 | Italy-N |address |phone | 30 | denmar |address |phone | 40 | Here i need to do the sum(amount), how to do this in shell scripting Thanks Babu (11 Replies)
Discussion started by: ksmbabu
11 Replies

2. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

3. Shell Programming and Scripting

Compare - 1st col of file

Hi, I have two different files, one has two columns and other has only one column. I would like to compare the first column in the first file with the data in the second file and write a third file with the data that is not present is not common to them. First file:... (26 Replies)
Discussion started by: swame_sp
26 Replies

4. Shell Programming and Scripting

Get columns from another file for match in col 2 in 1st file

Hi, My first file has 592155 9 rs16916098 1 592156 19 rs7249604 1 592157 4 rs885156 1 592158 5 rs350067 12nd file has 9 rs16916098 0 113228129 2 4 19 rs7249604 0 58709070 4 2 2 rs17042833 0 113558750 4 2... (2 Replies)
Discussion started by: genehunter
2 Replies

5. UNIX for Advanced & Expert Users

Print line based on highest value of col (B) and repetion of values in col (A)

Hello everyone, I am writing a script to process data from the ATP world tour. I have a file which contains: t=540 y=2011 r=1 p=N409 t=540 y=2011 r=2 p=N409 t=540 y=2011 r=3 p=N409 t=540 y=2011 r=4 p=N409 t=520 y=2011 r=1 p=N409 t=520 y=2011 r=2 p=N409 t=520 y=2011 r=3 p=N409 The... (4 Replies)
Discussion started by: imahmoud
4 Replies

6. Shell Programming and Scripting

Printing from col x to end of line, except last col

Hello, I have some tab delimited data and I need to move the last col. I could hard code it, awk '{ print $1,$NF,$2,$3,$4,etc }' infile > outfile but it would be nice to know the syntax to print a range cols. I know in cut you can do, cut -f 1,4-8,11- to print fields 1,... (8 Replies)
Discussion started by: LMHmedchem
8 Replies

7. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

8. Shell Programming and Scripting

Modifying col values based on another col

Hi, Please help with this. I have several excel files (with and .xlsx format) with 10-15 columns each. They all have the same type of data but the columns are not ordered in the same way. Here is a 3 column example. What I want to do add the alphabet from column 2 to column 3, provided... (9 Replies)
Discussion started by: newbie83
9 Replies

9. Shell Programming and Scripting

Replace col 23 - 26 with new value, non delimited file

hello, i have a undelimited file which contains 229 byte records. i want to change column 23 - 26 with a new value and also change the sign of the data in colulmn 30 - 70. i've tried SED for the first change, but nothing happens: sed 's/\(^.\{22\}\).\{4\}\(.*\)/\0603\2/' inputfile heres an... (8 Replies)
Discussion started by: blt123
8 Replies

10. Shell Programming and Scripting

Justif orden col raw file

Hi All, I need order file some, e.g. $cat file data description importantainfo 121 desp1 info1 122 desp2 info21 2342 desp3 info32 5345 desp4 info43 the how can make file but out formating $cat file (adjunt image) thank you (2 Replies)
Discussion started by: aav1307
2 Replies

LEARN ABOUT DEBIAN

sup-add

SUP-ADD(1)						      General Commands Manual							SUP-ADD(1)

NAME

       sup-add - add a source to the Sup source list

SYNOPSIS

       sup-add [options] [source uri...]

DESCRIPTION

       Add one ore more sources to the Sup source list

       For mbox files on local disk, use the form:

	      mbox:<path to mbox file>, or

	      mbox://<path to mbox file>

       For Maildir folders, use the form:

	      maildir:<path to Maildir directory>; or

	      maildir://<path to Maildir directory>

OPTIONS

       --archive, -a
	      Automatically archive all new messages from thesesources.

       --unusual, -u
	      Do not automatically poll these sources for new messages.

       --labels, -l label
	      A comma-separated set of labels to apply to all messages from this source

       --force-new, -f
	      Create a new account for this source, even if one already exists

       --force-account, -o account
	      Reuse previously defined account user@hostname

       --version, -v
	      Print version and exit

       --help, -h
	      Show help message

FILES

       $HOME/.sup/sources.yaml	     Configuration file for Sup mail sources

SEE ALSO

       sup-mail(1), sup-config(1)

AUTHOR

       Sup was written by William Morgan <wmorgan-sup@masanjin.net>.

       This manual page was written by Per Andersson <avtobiff@gmail.com> for the Debian project (but may be used by others).

								   April 9, 2012							SUP-ADD(1)
All times are GMT -4. The time now is 02:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy