Find & Replace

gagansharma · #1 (**permalink**) 11-27-2001

I get a text file with 70+ columns (seperated by Tab) and about 10000 rows. The 58th Column is all numbers. But sometimes 58th columns has "/xxx=##" after the numeric data. I want to truncate this string using the script. Any Ideas...

doeboy · #2 (**permalink**) 11-27-2001

You could use sed to strip that string out of the lines that have it.

gagansharma · #3 (**permalink**) 11-27-2001

Thanks, but the problem is bigger. The string "/xxx=##" exists at many other columns too. Even the string along with the numeric data in 58th column exists at many other places.

e.g. I have row one A B C, row two B A C, row three A A A. And I need to change it to row one A B C, row two B D C, row three A D A. That is where ever there is A in Column two replace with D, leave rest as is.

Perderabo · #4 (**permalink**) 11-27-2001

Use "cut" to split the file into three pieces with the middle piece being the column you want to modify. Then modify it. Then use "paste" to reassemble the three pieces back to a single file.

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 09:00 AM
find and replace	rakshit	Shell Programming and Scripting	4	01-24-2008 03:52 AM
find and replace	mahabunta	UNIX for Dummies Questions & Answers	7	09-21-2006 12:05 PM
find and replace	valhutch	UNIX for Dummies Questions & Answers	4	07-29-2006 05:20 PM
find and replace	vikas_j@hotmail	UNIX for Dummies Questions & Answers	3	02-25-2002 05:41 PM

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


	Powered by