Substitution problem.

er_ashu · #1 (**permalink**) 04-03-2007

Hi,
Just need some help in this.
Suppose there is one file a.txt, which contains this data:

"25187","00000022","00",28-MAR-2007,"" ,"D",-000001550,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ,29-MAR-2007
613TB.STEXTRF1
"25187","0000004H","00",29-MAR-2007,"" ,"H",-001769013,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ,29-MAR-2007

I need to substitute the value in the last value i.e. 29-MAR-2007 of every row with 02-APR-2007 so that it becomes
"25187","00000022","00",28-MAR-2007,"" ,"D",-000001550,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ,02-APR2007
613TB.STEXTRF1
"25187","0000004H","00",29-MAR-2007,"" ,"H",-001769013,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ,02-APR-2007

how can I do it in awk.
Please help.

Regards
Ashu

anbu23 · #2 (**permalink**) 04-03-2007

Code:

awk -F"," -v OFS="," ' { sub("29-MAR-2007","02-APR-2007",$NF); $1=$1; print } ' file

er_ashu · #3 (**permalink**) 04-03-2007

Thanks a lot.

Yogesh Sawant · #4 (**permalink**) 04-03-2007

in perl:

Code:

$ perl -pi -e 's/29-MAR-2007(\s+)$/02-APR-2007\1/' filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
VI Substitution problem	gravy26	AIX	7	02-13-2008 04:12 PM
Bash: bad substitution problem...pls help!	xfouxs	UNIX for Dummies Questions & Answers	1	11-23-2007 05:48 PM
ksh substitution	solea	Shell Programming and Scripting	2	08-09-2004 05:30 AM
bad substitution problem (easy question)	champion	UNIX for Dummies Questions & Answers	10	07-01-2002 11:16 PM
Substitution using sed	Ohji	UNIX for Dummies Questions & Answers	3	08-17-2001 11:32 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