fixed length falt file

sudheer05 · Post by **sudheer05** » Fri Dec 09, 2005 4:33 pm

Hi,
I am having a fixed length flatfile coming
It has a comma " , " in few records coz of this I am getting warnings

XfmRIMSClaims_mask..xtract_source.DSLink1: read_delimited() - row 22030, too many columns in record

But I am not able to get rid of these warnings, is there any possibility that i can write a function to replace the incoming comma with a space.

Thanks in advance,
sudheer

chucksmith · Post by **chucksmith** » Fri Dec 09, 2005 5:35 pm

Have you specified fixed width columns on the format tab? Try setting the column delimiter from a comma to 000.

sudheer05 · Post by **sudheer05** » Tue Dec 13, 2005 10:54 pm

Hi chucksmith,
thanxs for your reply, thats not my problem, anyway i fixed it.
thaxs again

chucksmith wrote:Have you specified fixed width columns on the format tab? Try setting the column delimiter from a comma to 000.

sasi_kumarreddy · Post by **sasi_kumarreddy** » Wed Dec 14, 2005 6:09 am

will u share your solution with us.