Focal Point
[CLOSED] Spaces in Alphanumeric/Varchar fields

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/630101192

November 12, 2009, 07:03 AM
sidney_jec
[CLOSED] Spaces in Alphanumeric/Varchar fields
HI
Is there any way that I can fix the length of a field.
For eg I have a field in which the values may vary from 2 -10 characters. But the length of the field is 15 characters and I want it to be displayed as 15 characters long only in the output.

I looked for different data types in here but could not find any?

Thanks in advance Smiler

This message has been edited. Last edited by: Kerry,


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
November 12, 2009, 09:19 AM
GinnyJakes
I'm not quite sure what you are asking but try (and look up) this setting:
SET SHOWBLANKS=ON

You don't mention your output type or which release of 7.6 you are using or your platform. If you put the latter two in your profile signature, it will be much easier to give you a targeted answer.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
November 12, 2009, 11:17 AM
Darin Lee
You also need to make sure that SQUEEZE is not on for that column in the stylesheet. The output type will make a big difference (HTML will not be handled the same way as PDF.)
Another idea is to make the field A15 if it is currently A15V.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
November 13, 2009, 12:30 AM
sidney_jec
i can't use SHOWBLANKS in my version of Webfocus ie 7.1.4..
and i have to make sure that the Define field that i would create and use in the header is displayed with its maximum length and not squeez.

For Eg: i want the header to be displayed like this:
if "Sachin Tendulkar" is the value of the defined field temp:

"Sachin Tendulkar is a genius."

if I change "Sachin Tendulkar" to "Sachin" then I should get the following output:

"Sachin           is a genius."   

This message has been edited. Last edited by: sidney_jec,


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
November 13, 2009, 04:22 AM
Danny-SRL
Sidney,
If your output is PDF, the blanks should show.
If you output is HTML and you cannot use SHOWBLANKS, then you will have to use
 "&|nbsp;" 
instead of a space so that the browser should insert blanks. Also see to your font: if you use something like "arial" then the blanks are very skinny, so maybe you want to use a fixed font like "courier new"


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

November 13, 2009, 04:40 AM
sidney_jec
Thanks..
but what if the output is word perfect??


_________________________________________________________________

WF Server: 7.1.4 on Unix and Win2K3 server, ReportCaster, Self-Service, MRE, Java
Data: Teradata, Oracle, SQL Server Output: HTML,PDF,EXL2K, WP
WF Client: 7.1.4 on Windows 2K3 w/Tomcat
November 13, 2009, 09:40 AM
GinnyJakes
Can you use CTRAN to replace the spaces with non-printable characters?


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
November 13, 2009, 10:09 AM
GamP
TABLE FILE CAR
PRINT COMPUTE FIELD1/A15 = 'Sachin Tendukar';
      COMPUTE FIELD2/A13 = ' is a genius';
      COMPUTE FIELD3/A29 = FIELD1 | FIELD2;
BY COUNTRY NOPRINT
ON TABLE HOLD FORMAT WP
END
TYPE HOLD.WP
TABLE FILE CAR
PRINT COMPUTE FIELD1/A15 = 'Sachin';
      COMPUTE FIELD2/A13 = ' is a genius';
      COMPUTE FIELD3/A29 = FIELD1 | FIELD2;
BY COUNTRY NOPRINT
ON TABLE HOLD FORMAT WP
END
TYPE HOLD.WP

Or is this not what you mean?


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988