Find and replace - UNIX for Dummies Questions & Answers

kiran_418 · #1 05-06-2008

Hi,
I am trying to do this find and replace in unix and somehow its not working.

Quote:

nawk -F'|' 'NF != 8 {printf "%s||\n", $0 }' catman_852_header.txt>header
nawk -F'|' 'BEGIN{OFS="|";}{ if ($9 != "CC"){$9="CC";} print }' header>header1

TR|20080325|22952 |000000040|20080327|0530
TR|20080417|23078 |000000104|20080418|0530|1040001 |

I have the records coming in the above format. My requirement is if delimiter count is not 8 then put in the missing 2 delimiters. THen at the end of the file place CC.
This one fails when at position 8 I get some data. ITs inserting
TR|20080417|23078 |000000104|20080418|0530|1040001 | CC||

I dont want those 2 extra delimiters at the end. IT should be

TR|20080417|23078 |000000104|20080418|0530|1040001 | CC.
TR|20080325|22952 |000000040|20080327|0530||CC.

Can anyone please help me out.

Thanks
Kiran

radoulov · #2 05-06-2008

Something like this?
(use nawk or /usr/xpg4/bin/awk on Solaris)

Code:

awk 'NF=8{$NF=$NF"CC"}1' FS=\| OFS=\| file

kiran_418 · #3 05-06-2008

awesome!!
it worked
THanks

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
find and replace	javeed7	Shell Programming and Scripting	1	04-02-2008 06:00 AM
find and replace	mahabunta	UNIX for Dummies Questions & Answers	7	09-21-2006 09:05 AM
find and replace	valhutch	UNIX for Dummies Questions & Answers	4	07-29-2006 02:20 PM
find and replace	vikas_j@hotmail	UNIX for Dummies Questions & Answers	3	02-25-2002 02:41 PM
Find & Replace	gagansharma	Shell Programming and Scripting	3	11-27-2001 01:17 PM

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