Replace specific columns - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Replace specific columns

google unix.com

Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
how to use vi to replace specific line of text only	pranav.pandya	UNIX for Dummies Questions & Answers	4	09-12-2008 10:03 AM
how to differentiate columns of a file in perl with no specific delimiter	Amiya Rath	Shell Programming and Scripting	9	07-15-2008 01:51 AM
How can i replace certain columns in the file	mani_um	Shell Programming and Scripting	6	06-22-2007 11:40 AM
Deleting specific columns from a file	premar	Shell Programming and Scripting	11	02-14-2006 07:02 AM
searching text files on specific columns for duplicates	Gerry405	UNIX for Dummies Questions & Answers	2	08-18-2005 11:51 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

10-13-2008

jisha

Registered User

Join Date: Jan 2008

Location: Bangalore,India

Posts: 144

Replace specific columns

hi All,

Thi sis very urgent.

I have large files with pipe delimited.
For example:
1.txt
1001024|120|9|-0.0|#|
1001025|120|9|#|
1001026|120|9|#|
1001032|120|2|-0.0|#|
1002026|110|9|#|
1002027|110|9|-0.0|#|
1002028|120|1|1.0|#|

I need to replace the 4th filed if it is # by |-|
my final txt file should like like below;

2.txt (out put)
1001024|120|9|-0.0|#|
1001025|120|9|-|
1001026|120|9|-|
1001032|120|2|-0.0|#|
1002026|110|9|-|
1002027|110|9|-0.0|#|
1002028|120|1|1.0|#|

Please help
Thanks in advance
JS

Bookmarks

« How to send XML data using HTTP Post Request | Can users be notified of the disk failures. »

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 Switch to Hybrid Mode Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

All times are GMT -4. The time now is 01:52 PM.