Removing tabs from a column

tmcnicol · Post by **tmcnicol** » Tue May 01, 2007 5:57 am

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.

chulett · Post by **chulett** » Tue May 01, 2007 6:42 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue May 01, 2007 3:05 pm

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.