[SATLUG] searching for a hexvalue with vi
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