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.
1001 121 Bytes & Words 170428 00001915796 CREDIT
1002 127 RAM Data Systems, Inc. 170428 00001520963 CREDIT
1003 124 Barton and Associates 170428 00000097700 CREDIT
1004 121 Bytes & Words 170428 00000182415 CREDIT
1005 109 Compdat Computer Consulting 170428 00001762511 CREDIT
1006 116 Compumasters Computer Supply 170428 00000336028 CREDIT
1007 112 Computer Medical Ctr. 170428 00000766318 CREDIT
1008 103 Computer Mountain Inc., 170517 00000453638 CREDIT
1009 100 Computer Warehouse - II 170518 00000806467 CREDIT
1010 106 Computer Warehouse - I 170520 00000234674 CREDIT
1011 117 Data Solutions 170528 00000604850 CREDIT
1012 115 Datacrafters Infosystems 170529 00000629889 CREDIT
1013 104 Industrial Concepts Inc. 170628 00000488496 CREDIT
1014 126 Johnson Technologies 170629 00000205217 CREDIT
1015 120 Lanufacturers Discount Computers 170711 00000185579 CREDIT
1016 122 Microcomputer Distribution 170712 00000427012 CREDIT
1017 122 Microcomputer Distribution 170728 00000463948 CREDIT
1018 101 Microtech University - I 170729 00000185579 CREDIT
1019 111 Microtech University - II 170803 00000206199 CREDIT
1020 107 Midtown Computer Co. 170812 00000302425 CREDIT
1021 125 MIS by Design 170814 00000151213 CREDIT
1022 119 Modular Software, Inc. 170826 00000528262 CREDIT
1023 108 Nordan Distributors, Inc. 170827 00000615651 CREDIT
1024 114 Olympic Sales 170827 00001173371 CREDIT
1025 114 Olympic Sales 170827 00000352012 CREDIT
1026 114 Olympic Sales 170827 00000631362 CREDIT
1027 118 Open Systems I/O 170902 00000260749 CREDIT
1028 105 PC Consultation And Design 170903 00001030995 CREDIT
1029 105 PC Consultation And Design 170911 00000302425 CREDIT
1030 110 Softech Database Design 170928 00001209701 CREDIT
1031 127 RAM Data Systems, Inc. 170929 00001173371 CREDIT
1032 110 Softech Database Design 171012 00000205217 CREDIT
1033 113 State University 171123 00000264131 CREDIT
1034 123 The Data Shop 171123 00000513043 CREDIT
1035 102 Industrial Computers Inc. 171123 00000660328 CREDIT
1036 109 Compdat Computer Consulting 171123 00001762511 CREDIT
1037 124 Barton and Associates 171123 00000102609 CREDIT
1038 114 Olympic Sales 171125 00001131149 CREDIT
1039 127 RAM Data Systems, Inc. 171126 00000185579 CREDIT
1040 121 Bytes & Words 171129 00000361831 CREDIT
1041 109 Compdat Computer Consulting 171129 00002155271 CREDIT
1042 127 RAM Data Systems, Inc. 171203 00001076654 CREDIT
1043 116 Compumasters Computer Supply 171215 00000470003 CREDIT
1044 127 RAM Data Systems, Inc. 171230 00000648490 CREDIT
1051 121 Bytes & Words 180105 00000661528 CREDIT
1052 116 Compumasters Computer Supply 180112 00000383159 CREDIT
1053 127 RAM Data Systems, Inc. 180105 00000797794 CREDIT
1054 124 Barton and Associates 180106 00001480705 CREDIT
1055 127 RAM Data Systems, Inc. 180106 00001696614 CREDIT
1056 116 Compumasters Computer Supply 180114 00000848253 CREDIT
1057 127 RAM Data Systems, Inc. 180112 00000215528 CREDIT
1058 127 RAM Data Systems, Inc. 180113 00000940006 CREDIT
1059 124 Barton and Associates 180114 00000542500 CREDIT
1060 109 Compdat Computer Consulting 180115 00000568030 CREDIT
1061 121 Bytes & Words 180116 00002329754 CREDIT
1062 127 RAM Data Systems, Inc. 180117 00000117338 CREDIT
1063 127 RAM Data Systems, Inc. 180118 00002155271 CREDIT
1064 127 RAM Data Systems, Inc. 180119 00000151213 CREDIT
1065 127 RAM Data Systems, Inc. 180120 00000336792 CREDIT
1066 121 Bytes & Words 180121 00000308317 CREDIT
1067 128 Renaissance Computer Company 180121 00000616633 CREDIT
1068 127 RAM Data Systems, Inc. 180122 00002346850 CREDIT
1069 124 Barton and Associates 180123 00000151213 CREDIT
1070 129 Blue Ridge Technologies, Inc. 180124 00000302425 CREDIT
1071 106 Computer Warehouse - I 180125 00000302425 CREDIT
1072 129 Blue Ridge Technologies, Inc. 180126 00000431054 CREDIT
1073 127 RAM Data Systems, Inc. 180127 00000383159 CREDIT
1074 129 Blue Ridge Technologies, Inc. 180127 00001880120 CREDIT
1075 127 RAM Data Systems, Inc. 180128 00000884692 CREDIT
1076 127 RAM Data Systems, Inc. 180129 00000215528 CREDIT
1077 129 Blue Ridge Technologies, Inc. 180130 00000548392 CREDIT
1078 116 Compumasters Computer Supply 180131 00002275008 CREDIT
1079 100 Computer Warehouse - II 180201 00002897587 CREDIT
1080 127 RAM Data Systems, Inc. 180202 00002700716 CREDIT
1081 127 RAM Data Systems, Inc. 180203 00002155271 CREDIT
1082 127 RAM Data Systems, Inc. 180204 00000491905 CREDIT
1083 127 RAM Data Systems, Inc. 180205 00000352502 CREDIT
1084 127 RAM Data Systems, Inc. 180206 00000151213 CREDIT
1085 121 Bytes & Words 180207 00003525021 CREDIT
1086 116 Compumasters Computer Supply 180208 00000176252 CREDIT
1087 121 Bytes & Words 180209 00000092790 CREDIT
1088 129 Blue Ridge Technologies, Inc. 180210 00000176252 CREDIT
1089 129 Blue Ridge Technologies, Inc. 180211 00000215528 CREDIT
1090 127 RAM Data Systems, Inc. 180212 00002285809 CREDIT
1091 127 RAM Data Systems, Inc. 180213 00002155271 CREDIT
1092 124 Barton and Associates 180214 00000469348 CREDIT
1093 124 Barton and Associates 180215 00000347593 CREDIT
1094 127 RAM Data Systems, Inc. 180216 00000151213 CREDIT
1095 127 RAM Data Systems, Inc. 180217 00000176252 CREDIT
1096 127 RAM Data Systems, Inc. 180218 00000185579 CREDIT
1097 127 RAM Data Systems, Inc. 180219 00000783556 CREDIT
1098 127 RAM Data Systems, Inc. 180219 00000302425 CREDIT
1099 127 RAM Data Systems, Inc. 180219 00002458187 CREDIT
1101 127 RAM Data Systems, Inc. 180219 00001026086 CREDIT
1102 127 RAM Data Systems, Inc. 180219 00001762511 CREDIT
1103 116 Compumasters Computer Supply 180219 00000976991 CREDIT
1104 127 RAM Data Systems, Inc. 180219 00003525021 CREDIT