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.
