ASCII 255 is another option for a hard space. Steve
From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of Bruce Chitiea Sent: Saturday, November 4, 2023 9:39 AM To: rbase-l@googlegroups.com Subject: Re[2]: [RBASE-L] - creating text file with blank spaces in tact 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<mailto:rby...@safesectors.com> (909) 238-9012 m ------ Original Message ------ >From "James W Kim, CPA, MBA" ><james....@kimcpa.com<mailto:james....@kimcpa.com>> To rbase-l@googlegroups.com<mailto: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<mailto: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<mailto:rbase-l@googlegroups.com> <rbase-l@googlegroups.com><mailto:rbase-l@googlegroups.com> Cc: james....@kimcpa.com<mailto: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<mailto:rby...@safesectors.com> (909) 238-9012 m ------ Original Message ------ >From "James W. Kim, CPA, MBA" ><james....@kimcpa.com<mailto:james....@kimcpa.com>> To rbase-l@googlegroups.com<mailto:rbase-l@googlegroups.com> Cc james....@kimcpa.com<mailto: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 --- 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 --- 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 --- 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/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<mailto: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<mailto: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<mailto: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<https://groups.google.com/d/msgid/rbase-l/eme6483f5d-d8c2-4cde-8f0a-adca6aedd988%40ffc94789.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/BYAPR03MB371816C7AEB9E2EE690A404289A4A%40BYAPR03MB3718.namprd03.prod.outlook.com.