Rob: You can easily use format the numbers with leading zeroes by using the FORMAT function; you might have to play with it as the FORMAT function adds a blank space in front of the formatted number (for the sign???) and you will need to trim it but this is easy as the result of the FORMAT function is a text value. For the text values I believe that the string replace function SRPL now allows replacement of blanks (with zeroes of whatever character you need) 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: Tuesday, February 28, 2006 6:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Fixed Position File Export 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
