You may try generating the file as you did before and then use one of hundred "freeware" utilities to replace the carriage return and linefeed with a blank or remove them all together. You can run the replace utility from within an R:Base application using the "ZIP" or "ZIP RETURN" commands.
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln., Suite #14 Olathe, KS 66062-4571 (913)829-0888 (913)649-2904 FAX -----Original Message----- From: [EMAIL PROTECTED] [mailto:owner-rbase-l@;sonetmail.com]On Behalf Of Chuck Novack Sent: Monday, November 11, 2002 11:32 PM To: [EMAIL PROTECTED] Subject: EDI without CR/LF Howdy! My client submits a data file to a state agency using zmodem. The old file format was simple. A header record, followed by a series of detail records followed by a footer record. Welcome to the new world of EDI. NEW FILE FORMATS! The new file is (a) significantly more complex and (b) does not allow CR of LF characters. It uses "group" "segment" and "field" identifiers and creates, in essence, 1 file with one rather large (perhaps a 250,000 + byte) record. Mainframers Ughh. I have dealt with the file complexities (the state will only let me submit 4 test files a week for testing 100's of data elements), but the lack of Carriage Returns and Line Feeds has not been resolved for production purposes. My client is very happy with version R:Base 6.0 for DOS (running in a DOS Window under Win 98 in a Netware environment). He does not want to upgrade. Instead of writing out records, I have had success in appending the variable string to a "work variable" defined as a NOTE field. It works well ... but I have a 4K record size limit. OK for testing, but not production. When I switch it to a VAR CHAR it fails miserably. I've messed around with several alternatives ... Does anybody have an approach that is clean? I appreciate your input! Chuck [EMAIL PROTECTED] ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
