[SATLUG] searching for a hexvalue with vi

Borries Demeler demeler at biochem.uthscsa.edu
Thu Dec 20 16:12:23 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

Yes, Brad, thanks! That also works. Under Linux there are many ways to get the job
done :-)

-b.


More information about the SATLUG mailing list