Binary to ASCII

bkumar103 · Post by **bkumar103** » Wed Feb 25, 2009 3:16 am

Hi Praveen,
Or is it some non english character. Please check the NLS settings.
Try using column import stage.

Thanks,

thumati.praveen · Post by **thumati.praveen** » Wed Feb 25, 2009 3:26 am

bkumar103 wrote:Hi Praveen,
Or is it some non english character. Please check the NLS settings.
Try using column import stage.

Thanks,

Hi Birendra,

source file coming from Mainframe with some columns binary type and some columns CHAR type.

I tried using Cexport and Cimport stages I am not able to get it done.

Thanks,
Praveen.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 25, 2009 4:43 am

Have you tried Complex Flat File stage?

hemanthakumar · Post by **hemanthakumar** » Wed Feb 25, 2009 5:11 am

Hi,
Check this command in Unix sed 's/'`echo "\015"`'//g' filename for removing control characters in your file.