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. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203

rby...@safesectors.com
(909) 238-9012 m

------ Original Message ------
From "James W Kim, CPA, MBA" <james....@kimcpa.com>
To rbase-l@googlegroups.com
Date 11/4/2023 9:14:39 AM
Subject 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 <https://aka.ms/o0ukef>
--------------------------------------------------------------------------------
From:rbase-l@googlegroups.com<rbase-l@googlegroups.com> <mailto:rbase-l@googlegroups.com> on behalf of James W. Kim, CPA, MBA <james....@kimcpa.com> <mailto:james....@kimcpa.com>
Sent: Friday, November 3, 2023 7:51:31 PM
To:rbase-l@googlegroups.com<rbase-l@googlegroups.com> <mailto:rbase-l@googlegroups.com> Cc:james....@kimcpa.com<james....@kimcpa.com> <mailto:james....@kimcpa.com>
Subject: Re: [RBASE-L] - creating text file with blank spaces in tact

Bruce,
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.

Thanks again,
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 var
set 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; endif
output .vfile
WRITE .vline01 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%' WRITE .vline02 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%' WRITE .vline03 USING '%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%'
output screen
launch .vfile
return

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. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203

rby...@safesectors.com
(909) 238-9012 m


------ Original Message ------
From "James W. Kim, CPA, MBA" <james....@kimcpa.com>
To rbase-l@googlegroups.com <mailto:rbase-l@googlegroups.com>
Cc james....@kimcpa.com
Date 11/3/2023 1:29:45 PM
Subject [RBASE-L] - creating text file with blank spaces in tact

I'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

-- create 50 x 3 block without truncating blank spaces
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 <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 <mailto: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 <https://groups.google.com/d/msgid/rbase-l/68b28448-66d3-4f60-92de-a2f6a65e865c%40KimCPA.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php <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 <mailto: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 <https://groups.google.com/d/msgid/rbase-l/em602f62ce-ca97-4774-864b-8dc06782ca5b%40ffc94789.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php <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 <https://groups.google.com/d/msgid/rbase-l/7dbd0c2b-6846-46ee-8903-c277ebd3398f%40KimCPA.com?utm_medium=email&utm_source=footer>.
--
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 <https://groups.google.com/d/msgid/rbase-l/PH0PR11MB51123546272842A8AA0CF06DC7A4A%40PH0PR11MB5112.namprd11.prod.outlook.com?utm_medium=email&utm_source=footer>.

--
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 <https://groups.google.com/d/msgid/rbase-l/4c2e1c44-6a45-4d20-a2b8-2e2efb8f337a%40KimCPA.com?utm_medium=email&utm_source=footer>.

--
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.

Reply via email to