Carriage Return in Flat File

[nick_bc]

Hello List,

I am having an issue with the Flat File Creation. I am using Table Conversion for creating Flat file. After using User Insert Row System Function, Rows are getting into flat file. Each line is having an extra char in the end which looks an carriage return to me. When transmitting this file to bank, only first record is being transmitted. Can some one shed some lights on it.

Thanks,

this is the sample we are transmitting to bank. The last char is an empty char here but in note pad, its a small rectabge shape.

"P","000","000111100","3333333","213123132","10/11/06","ABC, XYZ ","B","030995622001","100"
"P","000","050222220","44444444","5464645","10/11/06","JHKHKJ, ANNE ","B","030995622001","100"

 

[Zoltan_Gyimesi]

Hi Naveen,

Please, examine your text (flat) file with a hexa editor/viewer to determine exactly, what kind of character(s) is(are) on the line end and on the end of file.

I also did it many times, when I worked with In/Out interface text files and I had an issue with special characters.

Read you later & Regards,

Zoltán

 

[Mali]

I had the same issue.

That's a known bug. JDE have a fix in some tools release I had the troible in B9.

Each line you write ha s a end of Line character but no carraige return inserted that's what happens.

Rather than upgrading just for this teh work around we found was to open the TXT file in Note pad or Word pad (try both one should work Can't remember exactly) and just save it.

That will put carraige returns in place. Simple.

Mali