Yes, I would second the enhancement requests for SET TRIM ON/OFF and/or (NTRIM(text)) function. But for now I am hopeful that char(160) might solve some of the issues I had. Government upload file specifications typically say "blank space" without which ASCII characters they consider as "blank space."
--
James
James:
In broader context, I cannot swear that (CHAR(160)) serves as a "hard space" across the entire family of True Type fonts likely being used by, say Lacerte.
But I'm guessing you're not the only one tormented by gov't punch-card-era data formats.
So, maybe try an enhancement request (or two) along the lines of:
SET TRIM ON/OFF -- toggle all TRIM variants (default: ON)
(NTRIM(text)) -- Prevents trim of leading and trailing blanks from text.
Best, Bruce
Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203
(909) 238-9012 m
------ Original Message ------From "James W Kim, CPA, MBA" <james....@kimcpa.com>Date 11/4/2023 9:14:39 AMSubject Re: [RBASE-L] - creating text file with blank spaces in tact
--I was mainly trying out different values. Over the years, I have been using mixture of methods developed ad hoc to handle federal and state government uploads. I have been alternating between char(00) and char(32). Now, I am trying to figure out something that works reliably on all submissions and did not even consider extended ASCII. char(160) could be a game changer for me. I will see in the months to come.
--
James
On 11/4/2023 1:24 AM, randyp ctags.com wrote:
Why create a variable vspc rather than using the (char(160)) value in your SFIL?
I understand it is easier to test various values. Is there any other reason?
Randy Peterson.
PS. It's nice to know there is a (CHAR(160)) hard space. The result is similar to using a font that is not proportional, so number and other columns remain aligned on successive rows.Get Outlook for iOS
From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> on behalf of James W. Kim, CPA, MBA <james....@kimcpa.com>
Sent: Friday, November 3, 2023 7:51:31 PM
To: rbase-l@googlegroups.com <rbase-l@googlegroups.com>
Cc: james....@kimcpa.com <james....@kimcpa.com>
Subject: Re: [RBASE-L] - creating text file with blank spaces in tactBruce,--Thanks again,Thank you for the suggestion. char(160) works like a charm and does not get truncated. I will try this when I upload files next time. Hopefully the extended ASCII blank space is accepted. If there are any problems, I'll seek further assistance.
James
On 11/3/2023 6:06 PM, Bruce Chitiea wrote:
James: Try using the "hard space" character in place of the ASCII "soft space":
clear all varset var vSpc TEXT = (char(160))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; endifoutput .vfileWRITE .vline01 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'WRITE .vline02 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'WRITE .vline03 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'output screenlaunch .vfilereturn
Ok, so that only gets you the front end. Will think about the back end. Maybe SKEEP or SKEEPI are worth a look.
Best Regards, Bruce
Bruce A. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203
(909) 238-9012 m
------ Original Message ------From "James W. Kim, CPA, MBA" <james....@kimcpa.com>Date 11/3/2023 1:29:45 PMSubject [RBASE-L] - creating text file with blank spaces in tact
---- 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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/em602f62ce-ca97-4774-864b-8dc06782ca5b%40ffc94789.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/7dbd0c2b-6846-46ee-8903-c277ebd3398f%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51123546272842A8AA0CF06DC7A4A%40PH0PR11MB5112.namprd11.prod.outlook.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/4c2e1c44-6a45-4d20-a2b8-2e2efb8f337a%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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/eme6483f5d-d8c2-4cde-8f0a-adca6aedd988%40ffc94789.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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/aa59045b-694d-4f86-b7bf-3663365f909a%40KimCPA.com.