Replacing characters in csv file

finwhiz · #1 (**permalink**) 03-31-2008

Hello all,
This is my first post here, so please excuse me if this question is too obvious or has been asked before. I am new to Unix and although I tried to search your forum for the answer to my question, I could not find an answer that would help me.
I have a 500MB csv file with numeric values as percentages, i.e., 6.56%, or (4.35%). I need to replace the "%" with an empty character, the ")" also with an empty character, and the "(" with a "-" sign. Can someone point me to the right command in unix to do this? Standard Mac text editors blow up because of the size of the file.
Thanks a lot for your help!

Tytalus · #2 (**permalink**) 03-31-2008

Code:

#  echo "6.56%, or (4.35%)." | sed 's/[\%\)]//g;s/(/-/g'
6.56, or -4.35.

HTH

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
replacing characters	infyanurag	Shell Programming and Scripting	3	05-21-2008 01:55 AM
replacing the characters in a file	trichyselva	UNIX for Dummies Questions & Answers	2	01-03-2008 08:02 AM
Help Replacing Characters in Flat File	nelson553011	Shell Programming and Scripting	8	05-17-2007 11:57 AM
Replacing characters in file with line break	johnemb	Shell Programming and Scripting	10	04-26-2007 07:38 AM
replacing few characters in a file	purnakarthik	UNIX for Dummies Questions & Answers	1	01-25-2007 05:17 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