Archives of the TeradataForum

Message Posted: Mon, 25 Mar 2013 @ 09:51:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Jerico,

I tried this but, unluckily this is not working.

When I tried to view my file in Unix it is not showing the delimiter

     gunzip -c file1.gz | head -1
     148   ALBACETE   4

When I tired giving the cat -vet it was showing the delimieter as ^_, so I thought the delimeter would be in hex.(hex value for ^ is 5e and hex value for "_" is 5f)

     gunzip -c file1.gz | head -1| cat -vet
     148^_ ^_ ^_ ^_ALBACETE^_ ^_ ^_ ^_4$

Is there any way to handle this?

Thanks,

Vijay Mani

	<Prev	Next>		<<First	<Prev	Next>	Last>>