Sponsored Content
Operating Systems Linux Adding a prefix to a column using awk/sed commands Post 302483891 by R0H0N on Wednesday 29th of December 2010 01:04:03 AM
Old 12-29-2010
Input
Code:
$ cat file
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";
str .	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";
str .	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";

Command
Code:
sed 's/^\([0-9].*\)/char \1/g' file

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

See in the output, the starting string 'str' doesn't replaced with 'char'
R0H0N
 

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 ... (7 Replies)
Discussion started by: EAGL€
7 Replies

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... (2 Replies)
Discussion started by: gubbu
2 Replies

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 Replies)
Discussion started by: cosmologist
4 Replies

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 Replies)
Discussion started by: ad23
5 Replies

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 (4 Replies)
Discussion started by: venkatesht
4 Replies

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.... (2 Replies)
Discussion started by: mora
2 Replies

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 (5 Replies)
Discussion started by: chrisjorg
5 Replies

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 ))... (6 Replies)
Discussion started by: radudownload
6 Replies

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... (7 Replies)
Discussion started by: aniquebmx
7 Replies

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 (22 Replies)
Discussion started by: ranjancom2000
22 Replies
INTRO(4)						     Kernel Interfaces Manual							  INTRO(4)

NAME
intro - introduction to special files and hardware support DESCRIPTION
This section describes the special files, related driver functions, and networking support available in the system. In this part of the manual, the SYNOPSIS section of each configurable device gives a sample specification for use in constructing a system description for the /sys/conf/configscript, the autoconfig(8), program and descibes the major and minor device numbers and their encoding. The DIAGNOSTICS section lists messages which may appear on the console and/or in the system error log /usr/adm/messages due to errors in device operation. This section contains both devices which may be configured into the system, ``4'' entries, and network related information, ``4N'', ``4P'', and ``4F'' entries; The networking support is introduced in intro(4N). PDP DEVICE SUPPORT
This section describes the hardware supported on the DEC PDP-11. Software support for these devices comes in two forms. A hardware device may be supported with a character or block device driver, or it may be used within the networking subsystem and have a network interface driver. Block and character devices are accessed through files in the file system of a special type; c.f. mknod(8). Network interfaces are indirectly accessed through the interprocess communication facilities provided by the system; see socket(2). A hardware device is identified to the system at configuration time and the appropriate device or network interface driver is then compiled into the system. When the resultant system is booted, the autoconfiguration facilities in the system probe for the device on either the UNIBUS (or Q-bus) or MASSBUS and, if found, enable the software support for it. If a device does not respond at autoconfiguration time it is not accessible at any time afterwards. To enable a device which did not autoconfigure, the system will have to be rebooted. The autoconfiguration system is described in autoconfig(8). A list of the supported devices is given below. SEE ALSO
intro(4), networking(4), config(8). LIST OF DEVICES
The devices listed below are supported in this incarnation of the system. Pseudo-devices are not listed. Listed also are devices which are in various stages of porting to 2.11BSD from 4.3BSD. Devices are indicated by their functional interface. If second vendor products provide functionally identical interfaces they should be usable with the supplied software. (Beware, however, that we promise the software works ONLY with the hardware indicated on the appropri- ate manual page.) Occasionally, new devices of a similar type may be added simply by creating appropriate table entries in the driver. The following are known to work: acc ACC LH/DH IMP communications interface de DEC DEUNA 10Mb/s Ethernet controller dh DH-11 emulators, terminal multiplexor dhu DHU-11 terminal multiplexor dz DZ-11 terminal multiplexor ec 3Com 10Mb/s Ethernet controller hk RK6-11/RK06 and RK07 moving head disk ht TM03 MASSBUS tape drive interface (with TE-16, TU-45, TU-77) il Interlan 1010, 1010A, 2010A 10Mb/s Ethernet controller lp LP-11 parallel line printer interface qe DEC DEQNA Q-bus 10 Mb/s Ethernet interface ra DEC UDA-50, RQDX, KLESI disk controllers rk DEC RK05 disk controller rl DEC RL-11 disk controller rx DEC RX02 floppy interface si SI 9500 disk controller tm TM-11/TE-10 tape drive interface tmscp TMSCP-compatible tape controllers (e.g., TU81, TK50) ts TS-11 tape drive interface vv Proteon proNET 10Mb/s and 80Mb/s ring network interface xp General purpose SMD disk controller The following should work: dr DR-11W general purpose DMA UNIBUS interface The following worked in the past but will probably require work: css DEC IMP-11A communications interface dmc DEC DMC-11/DMR-11 point-to-point communications device en Xerox 3Mb/s Ethernet controller (obsolete) sri DR-11C IMP interface It should be possible to port these from 4.3BSD: ex Excelan 10Mb/s Ethernet controller ix Interlan NP-100 10Mb/s Ethernet controller np Interlan NP-100 10Mb/s Ethernet controller (intelligent mode) pcl DEC PCL-11 communications interface No idea whether any of the following could be ported: ad Data translation A/D interface ct C/A/T or APS phototypesetter ddn ACC ACP625 DDN Standard Mode X.25 IMP interface dmf DEC DMF-32 terminal multiplexor and parallel printer interface dmz DEC DMZ-32 terminal multiplexor dn DEC DN-11 autodialer interface hdh ACC IF-11/HDH IMP interface hp MASSBUS disk interface (with RP06, RM03, RM05, etc.) hy DR-11B or GI-13 interface to an NSC Hyperchannel kg KL-11/DL-11W line clock mt TM78 MASSBUS tape drive interface tu VAX-11/730 TU58 console cassette interface un DR-11W interface to Ungermann-Bass up Emulex SC-21V, SC-31 UNIBUS disk controller ut UNIBUS TU-45 tape drive interface uu TU58 dual cassette drive interface (DL11) va Benson-Varian printer/plotter interface vp Versatec printer/plotter interface 4th Berkeley Distribution January 27, 1996 INTRO(4)
All times are GMT -4. The time now is 09:57 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy