[SATLUG] searching for a hexvalue with vi

Brad Knowles brad at shub-internet.org
Thu Dec 20 15:37:10 CST 2007


On 12/20/07, Borries Demeler wrote:

>  Unfortunately, it doesn't tell me what i need to know. the problem I am
>  facing is that  a user sent me a csv file created with Micro$oft Excel,
>  and the program inserted a bunch of unused formula entries in random
>  fields which all turn out to be hex character 0xA0 (decimal 160, oct 240).
>  I want to strip this character with vi, or another simple app.

The CLI program "tr" is actually a better choice for this.  Try something like:

	% tr "\240" '?' < input > output

-- 
Brad Knowles <brad at shub-internet.org>
LinkedIn Profile: <http://tinyurl.com/y8kpxu>


More information about the SATLUG mailing list