I'm intrigued. I use something similar to create a notepad text file which I write to the user's desktop for them to use as a virtual "sticker" to keep up with a list of items to check off. I have trouble making it look good, the spacing is all over the place...
'COX-22222222-020118120001 02/01/18 $50.00' 'ENERGYSERVICECOMPANY-11111-010118100001 01/01/18 $100.00' Claudine -----Original Message----- From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of A. Razzak Memon Sent: Monday, February 19, 2018 7:07 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - Text file that retains trailing blank space James, Funny you should ask ... One of my financial and tax collection agency clients was required to submit the delinquent tax collection file for their GL package that required pretty much the same file format that you are required to use on your end. In addition to using the SFIL and SPUT commands to create the string, the key is to use the correct ASCII Symbol Character (CHAR(00)) for creating a blank line that should keep the trailing (BLANK) spaces. Using the sample RRBYW19 database, I have mocked up the actual procedure to create a text file to illustrate the use of SFIL and SPUT commands and maintaining the trailing spaces. See attached RRBYW19_FixedFieldFile.txt file. In this sample each line is 80 characters long. Using the MS Notepad, you will notice the trailing spaces. Note: If you need to open this file using the R:BASE Editor, make sure to enable the setting for [x] Keep Trailing Spaces. Otherwise, you will not be able to see any trailing spaces. If that is what you are looking for and need a sample application to illustrate the use of SFIL and SPUT to create Fixed Field File, feel free to reach out to me. Very Best R:egards, Razzak At 04:26 PM 2/19/2018, James W. Kim, CPA, MBA wrote: >Need some help with creating text file that retains blank spaces at the >end of each row. > >I often need to create text files with fixed row length such as 512 or >750 characters in a row. When there are no data value near the right >end of each row, the unused spaces need to be filled with blank spaces. > >The following is an example of how such text file would be built. >The example creates a >row that has "FLOOR 7" at 274th space in a row that has 512 characters. >With some previous versions of R:Base, the trailing spaces is retained >after insertion of data using SPUT function and line feed (CR/LF) would >show up at 513th position. > >However, the current version would remove the trailing space when data >is inserted using SPUT function and the (CR/LF) moves up to 281st >position. > >Is there anyway I can force the retention of trailing spaces so that >CR/LF always shows up at 513th position? -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
