Replace 1st column entires Post: 302935963

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Replace 1st column entires Post 302935963 by sasdf on Friday 20th of February 2015 05:31:46 PM

02-20-2015

Registered User

Replace 1st column entires

Hi,

I have an input file :

Code:

entries6091958        LEAN   assumption    11      112     0.999974        -       .       ID=hi_LEAN_10000003;
entries6091958        LEAN   prediction    11      112     0.999974        -       .       ID=hi_LEAN_10000003;
entries6091958        LEAN   CFD     11      112     .       -       0       pnt=chi_LEAN_10000003;
C6091988        LEAN   assumption    21      212     0.999974        -       .       ID=hi_LEAN_10000007;
C6091988        LEAN   prediction    21      212     0.999974        -       .       ID=hi_LEAN_10000007;
C6091988        LEAN   CFD     21      212     .       -       0       pnt=chi_LEAN_10000007;

My expected output file is

Code:

string6091958        LEAN   assumption    11      112     0.999974        -       .       ID=hi_LEAN_10000003;
string6091958        LEAN   prediction    11      112     0.999974        -       .       ID=hi_LEAN_10000003;
string6091958        LEAN   CFD     11      112     .       -       0       pnt=chi_LEAN_10000003;
string6091988        LEAN   assumption    21      212     0.999974        -       .       ID=hi_LEAN_10000007;
string6091988        LEAN   prediction    21      212     0.999974        -       .       ID=hi_LEAN_10000007;
string6091988        LEAN   CFD     21      212     .       -       0       pnt=chi_LEAN_10000007;

what i did so far is
1 sed 's/entries/string/g' : THIS REPLACED ALL entries by string in first column

2. then i did sed 's/C/string/g'

but it replaced the C in the CFD in third column.
I only want to replace in first column and retain data in other column entries

i am not sure how to proceed.

sasdf

View Public Profile for sasdf

Find all posts by sasdf

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace 10th column with a new column--- Terriblly hurry

Hi Can any one tell me how to replace the 10th column in a file(comma delimted) with a new file with a single column. Can any one Help me out of the please as soon as possible as i am in a terribley hurry!!!!!! Many THanks,

2. Shell Programming and Scripting

awk/sed column replace using column header - help

$ cat log.txt Name Age Sex Lcation nfld alias xsd CC 25 M XYZ asx KK Y BB 21 F XAS awe SS N SD 21 M AQW rty SD A How can I replace the column with header "Lcation" with the column with header "alias" and delete the "alias" column? so that the final output will become: Name Age Sex...

3. Solaris

How to remove setfacl entires for a file

I gave the permission for a user using Setfacl as folllows setfacl -m u:user:rwx,m:rwx /home/master To a home path of a master user When i try to remove the same it showing as $ setfacl -r s /home/master usage: setfacl -f aclfile file ... setfacl -d...

4. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2 file 1 sample SNDK 80004C101 AT XLNX 983919101 BB NETL 64118B100 BS AMD 007903107 CC KLAC 482480100 DC TER 880770102 KATS ATHR 04743P108 KATS...

5. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........

6. Shell Programming and Scripting

Remove bracket part entires and separate entries after comma

Hi all This time my input conatin 3 columns: ERCC1 (PA155) Platinum compounds (PA164713176) Allele A is not associated with response to Platinum compounds in women with Ovarian Neoplasms as compared to allele C . CES1 (PA107) methylphenidate (PA450464) Genotype CT is not...

7. Linux

Print the 1st column and the value in 2nd or 3rd column if that is different from the values in 1st

8. Shell Programming and Scripting

Get extract and replace column with link in a column where it exists

hi i have sample data a,b,c,d,e,g h http://mysite.xyx z,b,d,f,e,s t http://123124# a,b,c,i,m,nothing d,i,j,e,w,nothing output expected is a,b,c,d,e,http://mysite.xyx z,b,d,f,e,http://123124# a,b,c,i,m,nothing d,i,j,e,w,nothing i can get only links using grep -o 'http.*' i...

9. UNIX for Beginners Questions & Answers

Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd

hi I have 2 file with more than 10 columns for both 1st file apple,0,0,0...... orange,1,2,3..... mango,2,4,5..... 2nd file apple,2,3,4,5,6,7... orange,2,3,4,5,6,8... watermerlon,2,3,4,5,6,abc... mango,5,6,7,4,6,def....

10. UNIX for Beginners Questions & Answers

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy...

LEARN ABOUT REDHAT

setkeycodes

SETKEYCODES(8)							 Keyboard Support						    SETKEYCODES(8)

NAME

       setkeycodes - load kernel scancode-to-keycode mapping table entries

SYNOPSIS

       setkeycodes scancode keycode ...

DESCRIPTION

       The  setkeycodes  command  reads  its arguments two at a time, each pair of arguments consisting of a scancode (given in hexadecimal) and a
       keycode (given in decimal). For each such pair, it tells the kernel keyboard driver to map the specified scancode to the specified keycode.

       This command is useful only for people with slightly unusual keyboards, that have a few keys which produce scancodes that the  kernel  does
       not recognize.

THEORY

       The  usual  PC  keyboard  produces  a  series  of  scancodes  for  each	key press and key release. (Scancodes are shown by showkey -s, see
       showkey(1).)  The kernel parses this stream of scancodes, and converts it to a stream of keycodes (key  press/release  events).	 (Keycodes
       are  shown  by showkey.)  Apart from a few scancodes with special meaning, and apart from the sequence produced by the Pause key, and apart
       from shiftstate related scancodes, and apart from the key up/down bit, the stream of scancodes consists of unescaped scancodes xx (7  bits)
       and  escaped scancodes e0 xx (8+7 bits).  It is hardwired in the current kernel that in the range 1-88 (0x01-0x58) keycode equals scancode.
       For the remaining scancodes (0x59-0x7f) or scancode pairs (0xe0 0x00 - 0xe0 0x7f) a corresponding keycode can be  assigned  (in	the  range
       1-127).	For example, if you have a Macro key that produces e0 6f according to showkey(1), the command
	      setkeycodes e06f 112
       will assign the keycode 112 to it, and then loadkeys(1) can be used to define the function of this key.

OPTIONS

       None.

BUGS

       The keycodes of X have nothing to do with those of Linux.  Unusual keys can be made visible under Linux, but not under X.

SEE ALSO

       dumpkeys (1), loadkeys (1), showkey (1), getkeycodes (8)

Local								    8 Nov 1994							    SETKEYCODES(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace 10th column with a new column--- Terriblly hurry

Discussion started by: ahmedwaseem2000

2. Shell Programming and Scripting

awk/sed column replace using column header - help

Discussion started by: jkl_jkl

3. Solaris

How to remove setfacl entires for a file

Discussion started by: GIC1986

4. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

Discussion started by: rydz00