Thanks for your thoughts. In this case, however, the report option would not be ideally suited. With upload files for annual 1099 and W-2 reports for example, each row of specific length has to be filled in with various data items in specific columns. So, many lines of R:Base codes are needed to craft a single row. My problem has been that the blank spaces after hard data characters get trimmed whereas blank spaces need to fill the rest of row to the specified length (750 columns for 1099) followed by carriage return and line feed characters.
--
James
Hello James,
Maybe it is an idea to have a look at the report possibilities.
Print a report as a txt file is possible and there are a lot of options available.
open the report designer and choose for File | Print to Text File Setup
There you are able to create a TXT file in the way you like to have.
You can print the report as a file using the option TXT
Tony
Op 03-11-2023 om 21:29 schreef James W. Kim, CPA, MBA:
---- create 50 x 3 block without truncating blank spacesI'm trying to generate a text file shaped like a rectangle, where each row is of equal length and includes blank spaces. My aim is to create a rectangle that consists of 3 rows, each with 50 columns. However, I'm encountering an issue where the blank spaces are being truncated in the resulting text file. Does anyone have a reliable method for crafting a rectangular text box that preserves all blank spaces without trimming them?
I am currently using version X.5 build 10.5.5.20615
clear all var
set var vSpc TEXT = (char(32))
set var vfile text = ('test'+ format(.#date,'_YYYYMMDD')+ '.txt')
SET VAR vline01 TEXT = (SFIL(.vSpc,50))
SET VAR vline02 TEXT = (SFIL(.vSpc,50))
SET VAR vline03 TEXT = (SFIL(.vSpc,50))
set var vline01 = (sput(.vline01, 'DATA',1))
set var vline02 = (sput(.vline02, 'DATA',45))
set var vline03 = (sput(.vline03, 'DATA',30))
set var vifexist integer = (chkfile(.vfile))
if vifexist = 1 then; delete .vfile; endif
output .vfile
WRITE .vline01 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
WRITE .vline02 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
WRITE .vline03 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
output screen
launch .vfile
return
Thank you in advance,
James Kim
--
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 [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/68b28448-66d3-4f60-92de-a2f6a65e865c%40KimCPA.com.
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 [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/27bf3a52-8613-4a7f-9f81-dc5aff063a02%40cio-bv.nl.
--
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 [email protected].
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/44edeb5a-a3c1-4268-acf8-3869562e42a5%40KimCPA.com.
