Adding a prefix to a column using awk/sed commands Post: 302483888

Sponsored Content

Operating Systems Linux Adding a prefix to a column using awk/sed commands Post 302483888 by bjorngill on Wednesday 29th of December 2010 12:30:05 AM

12-29-2010

Registered User

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 column and I don't want to change them.
1 . miRNA 548816 548893 . + . ACC="MI0002023"; ID="dre-mir-155";
1 . miRNA 1651461 1651541 . + . ACC="MI0002180"; ID="dre-mir-459";
1 . miRNA 23269491 23269603 . - . ACC="MI0004786"; ID="dre-mir-740";
1 . miRNA 27656240 27656327 . + . ACC="MI0002052"; ID="dre-mir-218a-2";
1 . miRNA 34527751 34527843 . + . ACC="MI0004780"; ID="dre-mir-734";
1 . miRNA 40174414 40174523 . + . ACC="MI0010857"; ID="dre-mir-2197";
1 . miRNA 46862496 46862635 . - . ACC="MI0001895"; ID="dre-mir-16b";
1 . miRNA 46862739 46862822 . - . ACC="MI0001891"; ID="dre-mir-15a-1";
1 . miRNA 55355143 55355233 . - . ACC="MI0004765"; ID="dre-mir-722";
2 . miRNA 1085488 1085564 . + . ACC="MI0002181"; ID="dre-mir-460";
2 . miRNA 6031391 6031475 . + . ACC="MI0002000"; ID="dre-mir-137-1";
2 . miRNA 22105590 22105669 . - . ACC="MI0004782"; ID="dre-mir-736";
2 . miRNA 23568780 23568883 . - . ACC="MI0010841"; ID="dre-mir-2190";
2 . miRNA 25338635 25338716 . - . ACC="MI0001966"; ID="dre-mir-124-1";
2 . miRNA 31878456 31878533 . + . ACC="MI0001916"; ID="dre-mir-23a-3";
2 . miRNA 31880346 31880476 . + . ACC="MI0001928"; ID="dre-mir-27a";
2 . miRNA 34798348 34798457 . + . ACC="MI0010847"; ID="dre-mir-2198";
2 . miRNA 44164796 44164904 . - . ACC="MI0001366"; ID="dre-mir-181b-1";
2 . miRNA 57907954 57908073 . - . ACC="MI0001879"; ID="dre-mir-7a-3";

Is there any simple way to change the first column. Any help will be appreciated.

Thanks

bjorngill

View Public Profile for bjorngill

Find all posts by bjorngill

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk-adding a column to a file

Hello Friends, i used awk to sum up total size of files under a directory (with the help of examples, threads here). ls -l | awk '/^-/ {total += $5} END {printf "%15.0f\n",total}' >> total.txt After each execution of the script total result is appended into a text file: 7010 7794 8890 ...

2. 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...

3. 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:

4. 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...

5. Shell Programming and Scripting

Adding prefix to the values in the script

Hi, test.txt contains below values 1 2 3 4 5 Desired output: 'TT.1', 'TT.2', 'TT.3', 'TT.4', 'TT.5' Last value should not contain the comma after the value. Below is the script which i have tried. I'm using Linux. #!/bin/bash for i in $test.txt

6. UNIX for Dummies Questions & Answers

Adding Filename as column using sed

Hi , Can any one please tell me, how can we add the file name as column using sed. right now we are using the below awk command for adding the file name as column but when we are calling this script from datastage it is deleting the file data..very weird raised a support ticket with datastage....

7. Shell Programming and Scripting

AWK adding prefix/suffix to list of strings

75 103 131 133 138 183 197 221 232 234 248 256 286 342 368 389 463 499 524 538

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. Shell Programming and Scripting

Need to add prefix using sed or awk from cat the file

I need the use sed or AWK using cat the file Node1 TDEV RW 1035788 TDEV RW 1035788 Server1 TDEV RW 69053 Server2 TDEV RW 69053 TDEV RW 103579 Server3 TDEV RW 69053 server4 RDF1+TDEV RW 69053 RDF1+TDEV RW 517894 RDF1+TDEV RW 621473 server6 TDEV RW 34526 TDEV RW 34526

LEARN ABOUT DEBIAN

pull-lp-source

PULL-LP-SOURCE(1)					      General Commands Manual						 PULL-LP-SOURCE(1)

NAME

       pull-lp-source - download a source package from Launchpad

SYNOPSIS

       pull-lp-source [options] source package [release|version]

DESCRIPTION

       pull-lp-source  downloads  and  extracts  the  specified version of <source package> from Launchpad, or the latest version of the specified
       release.  To request a version from a particular pocket say release-pocket (with a magic -release for only the release pocket).	If no ver-
       sion or release is specified, the latest version in the development release will be downloaded.

OPTIONS

       Listed below are the command line options for pull-lp-source:

       source package
	      This is the source package that you would like to be downloaded from Launchpad.

       version
	      This is the version of the source package to be downloaded.

       release
	      This  is	the  release that you would like the source package to be downloaded from.  This value defaults to the current development
	      release.

       -h, --help
	      Display a help message and exit.

       -d, --download-only
	      Do not extract the source package.

       -m UBUNTU_MIRROR, --mirror=UBUNTU_MIRROR
	      Use the specified Ubuntu mirror.	Should be in the form http://archive.ubuntu.com/ubuntu.  If the package isn't found on	this  mir-
	      ror, pull-lp-source will fall back to Launchpad, as its name implies.

       --no-conf
	      Do not read any configuration files, or configuration from environment variables.

ENVIRONMENT

       All  of	the  CONFIGURATION  VARIABLES  below are also supported as environment variables.  Variables in the environment take precedence to
       those in configuration files.

       DIST   Specifies the default target.

CONFIGURATION VARIABLES

       The following variables can be set in the environment or in ubuntu-dev-tools(5) configuration files.  In  each  case,  the  script-specific
       variable takes precedence over the package-wide variable.

       PULL_LP_SOURCE_UBUNTU_MIRROR, UBUNTUTOOLS_UBUNTU_MIRROR
	      The default value for --mirror.

SEE ALSO

       dget(1), pull-debian-source(1), pull-debian-debdiff(1), ubuntu-dev-tools(5)

AUTHOR

       pull-lp-source  and  this manual page were written by Iain Lane <iain@orangesquash.org.uk>.  Both are released under the GNU General Public
       License, version 3 or later.

ubuntu-dev-tools						   4 August 2008						 PULL-LP-SOURCE(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk-adding a column to a file

Discussion started by: EAGL�

2. Shell Programming and Scripting

sed/awk-adding numeric to a column

Discussion started by: gubbu

3. UNIX for Dummies Questions & Answers

Adding a column with the row number using awk

Discussion started by: cosmologist

4. Shell Programming and Scripting

Adding column using awk

Discussion started by: ad23