Delimiter format for Fixed width

lak4u · Post by **lak4u** » Tue Mar 09, 2010 12:57 pm

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

chulett · Post by **chulett** » Tue Mar 09, 2010 1:14 pm

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.

lak4u · Post by **lak4u** » Tue Mar 09, 2010 1:46 pm

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