Yes Javier, that is an excellent idea! How did you handle prefixing both text and integer column/variables values with preceeding zero's? Where format masks used?
Thanks, Rob > -------- Original Message -------- > Subject: [RBASE-L] - RE: Fixed Position File Export > From: "Javier Valencia" <[EMAIL PROTECTED]> > Date: Mon, February 27, 2006 10:58 pm > To: [email protected] (RBASE-L Mailing List) > > Rob: > I did a lot of that in 6.5++ using reports without headers or footers and > had the length set to 0. I imagine you could do the same using 7.x, you > might even create a long variable with your format that you print in every > line using a mono-spaced font, something like: > vline = (LJS(col1,20) + LJS(col2,20) + RJS(CTXT(col3),20)... > and then in your report just print the variable vline in the detail line and > the save the file as a text file. > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Rob Vincent > Sent: Monday, February 27, 2006 9:49 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Fixed Position File Export > > > Is there a way to export data from Rbase in a fixed field position > format? > > I remember in the 'ole days, RBDOS 4.5Plus had a Fixed format export in > Gateway > where you would place [S]tart and [E]nd markers for the specified > fields. > > Never thought I would need this functionality again, BUT a customer > needs to supply > accounting information to a customer on a regular basis in this format. > > Looks like they are planning on importing this into some COBOL program > based on the > sample format they provided. > > Any recommendations on how I might be able to accomplish this would be > appreciated. > Thanks -- Rob --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
