This thread started ringing bells in my gray matter because this trailing 
blank issue has been around for years.  In the following list of links from 
the archive, the first one from myself is from 2015, wherein I lament the 
age of the particular behavior.
The few links after include pertinent thread responses and also one thread 
from James Kim regarding the issue and the subsequent response from Razzak 
for his personal workaround solution.  I would still be in favor of a DB 
setting to SET TRAIL ON/OFF in order to be able to provide a uniform and 
expected value for a space that would work on all platforms.  I know there 
are other ASCII and EXTENDED ASCII chars that mimic the Char(32), but as 
was discussed many times before, ALL systems do not digest them as genuine 
SPACE char.  When you use non-breaking-space in HTML "&nbsp", when the 
browser renders it to display, you can copy the resulting text and test the 
non-breaking-space and it is converted by the renderer to CHAR(32), as an 
example.
Anyway, I knew there was ancient discussions about this and you may find 
the links helpful, or not, your mileage may vary.
https://www.mail-archive.com/[email protected]/msg42411.html
https://www.mail-archive.com/[email protected]/msg02917.html
https://www.mail-archive.com/[email protected]/msg02920.html
https://www.mail-archive.com/[email protected]/msg02925.html
https://www.mail-archive.com/[email protected]/msg02928.html
https://www.mail-archive.com/[email protected]/msg02933.html


On Friday, November 3, 2023 at 4:29:49 PM UTC-4 James W. Kim, CPA, MBA 
wrote:

> 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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/bec12157-590b-4574-b509-1be13c4ce58dn%40googlegroups.com.

Reply via email to