Yeah I considered that but I know it's alot of trial and error to get everything to fit in the exact space it's supposed to be in. My line has 1500 of characters across so that would be way too much fooling around, and I'm not sure it would help anyway since I need those 675 blank spaces at the end. How would you place those blank spaces in a TXT report?
Karen -----Original Message----- From: Tony IJntema <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Sun, Jan 4, 2015 2:36 pm Subject: [RBASE-L] - RE: Fixed field file Have you tried using the report writer using option TXT? Look at file | print file setup Just have made a very complicated electronic invoice inluding 5 subreports and a lot of spaces and integers, which need to be filled with 000, it works like a charm. Tony From: [email protected] [mailto:[email protected]] On Behalf Of Karen Tellef Sent: zondag 4 januari 2015 21:15 To: RBASE-L Mailing List Subject: [RBASE-L] - Fixed field file I need to create a file with fixed field lengths. Rather than doing SFIL/SPUT I did a "select" statement and it works great and is easy to code, except... I need to have 675 blank spaces at the end of each line and I can't figure out how to do that using a "select" statement. Has anyone done that, or do I need to use SFIL/SPUT. According to my notes, if I use SFIL/SPUT I'll have to use a cursor and then do something like this (and thanks to whoever originally posted this code and I saved it): --Add CarriageReturn/LineFeed charaters to the line Set var vDataLine = (SPUT(.vDataLine,.vCRLF,.vPastEnd)) --Make sure no trash data exists beyond CR/LF Set var vDataLine = (SGET(.vDataLine,..vTotalLength,1)) --Write the line, telling RBASE not to add its own CRLF WRITE .vDataLine CONTINUE Karen
