How can i replace certain columns in the file - Shell Programming and Scripting

mani_um · #1 (**permalink**) 06-22-2007

Can i use sed command to replace certain column in the file

let say i hav

D1254215221542 MANA3DS2OOR454
C1254815221121 MDGA4GH4OOR454
A1254215221522 AFFA4DF4OODS54
S3454815221121 TDTA4GH465R454

I wanted to change only at postition 21 and 22 which is DS,GH,DF and GH
i want find that if that position is GH then change it to KH
so the output should be

D1254215221542 MANA3DS2OOR454
C1254815221121 MDGA4KH4OOR454
A1254215221522 AFFA4DF4OODS54
S3454815221121 TDTA4KH465R454

can i do in in sed command or any other simple command if you have
thanks

aigles · #2 (**permalink**) 06-22-2007

You can do something like that :

Code:

sed 's/^\(.\{20\}\)GH/\1KH/'  infile

matrixmadhan · #3 (**permalink**) 06-22-2007

Round about way!

Code:

awk '{ if( substr($0, 21, 2) ~ /GH/ ) { printf "%s%s%s\n", substr($0, 0, 20), "KH", substr($0, 23, length($0)) } else { print } }'  filename

mani_um · #4 (**permalink**) 06-22-2007

Thanks man
i will trying it out
it should work
thanks again

ghostdog74 · #5 (**permalink**) 06-22-2007

Code:

awk 'BEGIN{FS="";OFS=""}
     $21~"G" && $22 ~ "H"{ $21="K";}
	 {print }
' "file1"

aigles · #6 (**permalink**) 06-22-2007

Quote:

Originally Posted by ghostdog74

Code:

awk 'BEGIN{FS="";OFS=""}
     $21~"G" && $22 ~ "H"{ $21="K";}
	 {print }
' "file1"

This solution doesn't work with my version of awk under AIX. With an empty Input File Separator, the field 1 contains the whole record :

Code:

$ awk 'BEGIN{FS="";OFS=""}
>      { printf("$0=<%s>\n$1=<%s>\n", $0, $1) }
> ' rep.txt
$0=<D1254215221542 MANA3DS2OOR454>
$1=<D1254215221542 MANA3DS2OOR454>
$0=<C1254815221121 MDGA4GH4OOR454>
$1=<C1254815221121 MDGA4GH4OOR454>
$0=<A1254215221522 AFFA4DF4OODS54>
$1=<A1254215221522 AFFA4DF4OODS54>
$0=<S3454815221121 TDTA4GH465R454>
$1=<S3454815221121 TDTA4GH465R454>
$

ghostdog74 · #7 (**permalink**) 06-22-2007

I use GNU awk. Defining FS="" will set every character as individual fields.
output:

Code:

# ./test.sh
D1254215221542 MANA3DS2OOR454
C1254815221121 MDGA4KH4OOR454
A1254215221522 AFFA4DF4OODS54
S3454815221121 TDTA4KH465R454

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Adding columns to a file	figaro	UNIX for Dummies Questions & Answers	5	4 Weeks Ago 10:50 PM
add columns from file to another and sort	kamel.seg	Shell Programming and Scripting	12	12-12-2007 10:39 AM
have a file with 300 columns	dummy_needhelp	Shell Programming and Scripting	4	11-04-2007 09:08 PM
manipulate csv file to add columns	oscarmon	Filesystems, Disks and Memory	6	12-11-2006 05:47 AM
Appending columns on a file	abel	Shell Programming and Scripting	2	09-27-2002 04:04 AM

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode