Deleting end of line $ character in file

bwrynz1 · #1 (**permalink**) 01-08-2008

Hi, I've got a file where in the middle of the record is a $ end of line character, visible only when I open the file in vi and do :set list. How to I get rid of the character in the middle and keep it at the end. The middle $ character always appears after SW, so that can be used to tag it.
Normal row - Field 1, Field2,Field3, Field 4$
Bad row - Field 1, Field2SW$,
Field3, Field 4$

ranjithpr · #2 (**permalink**) 01-08-2008

awk '{ if(substr($0,length)==",") printf("%s ",$0); else print }' filename

bwrynz1 · #3 (**permalink**) 01-08-2008

Hi Ranjithpr;
I'm not getting the results I want... is there someway to tell the script to remove the $ character immediately after the SW and combine the two lines together.
Thanks so much for helping out.

jxh461 · #4 (**permalink**) 01-08-2008

Do the following within the file to remove SW$ .

:g/SW\$/s///

Then you can apply rangithpr's suggestion to give you a final fix

awk '{ if(substr($0,length)==",") printf("%s ",$0); else print }' filename

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
deleting a line but keeping the same file	laiko	UNIX for Dummies Questions & Answers	2	05-13-2008 02:08 PM
Need to serach if a new line character exists on the last line in a file	sunilbm78	UNIX for Dummies Questions & Answers	10	02-29-2008 02:15 PM
Deleting Junks at the end of each line in a file	dave_nithis	UNIX Desktop for Dummies Questions & Answers	5	10-05-2007 02:51 AM
Problem deleting file with special character	hart1165	UNIX for Dummies Questions & Answers	2	12-07-2005 11:29 AM
Deleting end line spaces for along file	osymad	Shell Programming and Scripting	3	02-23-2005 01:56 PM

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