Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

F007111 - Text file processor

edited Aug 1, 2013 6:25AM in Design Tools & Output Technologies - JDE1 (MOSC) 6 commentsAnswered
VA rpt_Detail_REC1 = concat([VA rpt_Detail_REC1],rpad([VA rpt_TapeDTAIL1]," ",119))
VA rpt_Detail_REC1 = concat([VA rpt_Detail_REC1],'\r')

Insert Text File Processor Detail


I am writing a Flat file for a bank draft.  The bank requires the file to have a carriage return in position 120. I cannot get this to work.  Our data is on the AS400 platform. I have no problems creating the record and the data is fine but the carriage return is getting added to the end of the last field in the record.  I have tried many concats, rightpad, leftpad, substring '\r' to the end. Is this an AS400 issue or what? I am trying to avoid writing a business function, but that seems like my only choice

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center