[SOLVED] Report dropping multiple spaces in character field.

Focal Point

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

June 07, 2011, 06:48 AM

mark66

[SOLVED] Report dropping multiple spaces in character field.

Hi all,

I am sure I have come across this before but I can't remember the fix or the keyword/function to help!

A user is complaining that a character field is dropping a double space between two words and only reporting a single space.

Example: (hyphens represent spaces)

Value on file = 'A--B'
Result in report EXL2K = 'A-B'

Any advice to retain the double spaces appreciated!

Cheers

Mark

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

June 07, 2011, 09:26 AM

Francis Mariani

Look into SHOWBLANKS:

  
SET SHOWBLANKS = ON

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server

June 14, 2011, 04:30 AM

mark66

Hi Francis,

Sorry for the late reply and yes SET SHOWBLANKS fixed the issue.

Many thanks!

Mark