DSXchange

My source file is delimited file and I need to poupulate fixed width file
but when I created the file, the empty field has #####. I tried to trim and tried to remove ###, still I couldn't, please help.

Thanks

A "fixed width file" means each record is exactly the same number of characters long and each field is always the same size, even when "empty". Use "char" fields and make sure you populate them appropriately - as in all spaces for the ones with no data.

chulett wrote:A "fixed width file" means each record is exactly the same number of characters long and each field is always the same size, even when "empty". Use "char" fields and make sure you populate them appropriately - as in all spaces for the ones with no data.

Thanks for reply.

Actually I found the solution. In the sequential file format tab there is Default padding "#". I removed this and its working fine.

Thanks you