Replace a Value in File

lesstjm · #1 (**permalink**) 05-16-2007

I have a pipe delimited file. I want to replace the contents of field 19 with the value USD. Does anyone know the command for this?

Shell_Life · #2 (**permalink**) 05-16-2007

Lesstjm,
Here is one solution using "sed":

Code:

sed -e 's/|/USD|/19' -e 's/\(.*\)|.*USD/\1|USD/' input_file

ghostdog74 · #3 (**permalink**) 05-16-2007

Code:

awk 'BEGIN{FS="|"}{$19="USD";$0=$0;print}' file

aigles · #4 (**permalink**) 05-16-2007

Try that:

Code:

awk -F'|' '{$19="USD"; print}' inputfile

lesstjm · #5 (**permalink**) 05-16-2007

awk 'BEGIN{FS="|"}{$19="USD";$0=$0;print}' file is giving me an error

$ awk 'BEGIN{FS="|"}{$19="USD";$0=$0;print}' US_RETAIL_WIRE_TRANS_20070504_00.TST
awk: can't set $0
record number 1

The next one awk -F'|' '{$19="USD"; print}' inputfile
is removing all of the pipes.

The sed command worked though.

Thanks for your help

aigles · #6 (**permalink**) 05-16-2007

Quote:

Originally Posted by lesstjm

The next one awk -F'|' '{$19="USD"; print}' inputfile
is removing all of the pipes.

The Output Field Separator must be set to '|'

Code:

awk 'BEGIN {FS=OFS="|"} {$19="USD"; print}' inputfile

Jean-Pierre.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Replace the file using sed	senthil_is	Shell Programming and Scripting	5	11-20-2008 07:58 AM
replace nth value in xml file	subin_bala	Shell Programming and Scripting	4	06-18-2008 02:39 PM
replace words in file based on another file	kinmak	Shell Programming and Scripting	9	05-07-2008 05:06 AM
Replace word in a file	sasiharitha	UNIX for Dummies Questions & Answers	3	12-05-2007 01:11 AM
serach and replace file name in the path in a remote xml file	kiranreddy1215	Shell Programming and Scripting	1	11-12-2007 11:31 AM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by