Page 1 of 1
Removing tabs from a column
Posted: Tue May 01, 2007 5:57 am
by tmcnicol
I have a table loaded via Excel where the last column of data contains what looks like a pipe but acts like a tab. How do I find out what the ASCII code is and then I should be able to use Convert to remove.
Posted: Tue May 01, 2007 6:42 am
by chulett
A hex editor or perhaps 'od' - an Octal Dump of the file. There should be a 'show hex' switch if you're more comfortable with that. Tell us what you find.
Posted: Tue May 01, 2007 3:05 pm
by ray.wurlod
As well as od -xc as suggested by Craig, you can use editors such as UltraEdit that can open the file via FTP and show it to you in hex.