Chuck, You can use the Varchar datatype and save it to a temporary file on disk. You can use VbScript to manipulate the file with the Launch Command. VbScript has excellent textfile handling capabilities....
----- Original Message ----- From: "Chuck Novack" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 12, 2002 12:32 AM 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/
