comma in column title

Exactly what I needed!

thanks,

Leo

Posts: 96 | Location: Winnipeg, Manitoba, Canada | Registered: January 22, 2004

Ignored post by Leo L posted

Steve McGuire

Member

posted

What if you are using EXL2K?

Posts: 1 | Location: McLean, VA | Registered: July 12, 2005

Ignored post by Steve McGuire posted

Prarie

Virtuoso

posted

Here's a thought if you don't mind an underscore...or you could white it out in the style sheet

DEFINE FILE CAR
FIRST_1,000 = SALES;
END
TABLE FILE CAR
PRINT FIRST_1,000
BY CAR
ON TABLE PCHOLD FORMAT EXL2K
END

In Focus since 1993. WebFOCUS 7.7.03 Win 2003

Posts: 1903 | Location: San Antonio | Registered: February 28, 2005

Ignored post by Prarie posted

Spence

Platinum Member

posted

you can define the field as First 1,000 and include the field in ' ' when printing.

DEFINE FILE CAR
FIRST 1,000 = SALES;
END
TABLE FILE CAR
PRINT 'FIRST 1,000'
BY CAR
ON TABLE PCHOLD FORMAT HTML
END

WF 8 version 8.2.04. Windows.
In focus since 1990.

Posts: 189 | Location: pgh pa | Registered: October 06, 2004

Ignored post by Spence posted

susannah

Expert

posted

jumpin jeehosafats
that actually works!
thanks spence

In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID

Posts: 3811 | Location: Manhattan | Registered: October 28, 2003

Ignored post by susannah posted

Expert

posted

We're now getting to the situation where something that shouldn't work, does.
All I would say is beware, because if you start to rely upon it you will soon find that in subsequent releases the behaviour will be tightened and you may find it no longer works.

Rule no.1 - Use undocumented features at your own risk!

T (harbinger of doom)

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Spence

Platinum Member

posted

this has always worked in the focus language way before webfocus.

WF 8 version 8.2.04. Windows.
In focus since 1990.

Posts: 189 | Location: pgh pa | Registered: October 06, 2004

Ignored post by Spence posted

Expert

posted

Spence,

The important thing is - is it a documented syntax?

I would guess the answer is no and therefore that is why I suggest caution.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Spence

Platinum Member

posted

T, I understand your point that this may be an undocumented feature. There have been file structures that allow for a field name to contain a space. In order for FOCUS to print a field with a space it needs to be included in single quotes.

SET ASNAMES = ON
TABLE FILE CAR
PRINT SALES AS 'CAR SALES'
BY COUNTRY
ON TABLE HOLD
END
? HOLD
TABLE FILE HOLD
PRINT 'CAR SALES'
BY COUNTRY
END
-EXIT

WF 8 version 8.2.04. Windows.
In focus since 1990.

Posts: 189 | Location: pgh pa | Registered: October 06, 2004

Ignored post by Spence posted

Expert

posted

Spence, I agree that the method that you have shown works and I find it very tempting to utilise that quirk, however, the following is from 4.3 documentation -

Valid characters in a name. All names must begin with a letter, and can include any combination of letters, numbers, and underscores ( _ ).

The names of applications, virtual servers, and deployment scenarios can also include embedded spaces. (Other types of names cannot include spaces.)

All I say is user beware.

T

In FOCUS since 1986	WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
	WebFOCUS App Studio 8.2.06 standalone on Windows 10

Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004

Ignored post by Tony A posted

Expert

posted