[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Double lined Headings in CSV



The Alt-Enter translates to CHR(10).

This should get you a two-line heading:
LET $Heading = 'Line 1' || CHR(10) || 'Line 2'

-----Original Message-----
From: sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org
[mailto:sqr-users-bounces+jeff.steinfeldt=wellsfargo.com@sqrug.org] On
Behalf Of Bruce Burnell
Sent: Monday, January 31, 2005 1:37 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Double lined Headings in CSV






We have an SQR that produces a .csv file.  We are doing this using the
'write' rather than 'print' verbs.  I recognize that is a point of debate in
itself, but we have found that for some extracts, it is much cleaner. Now
some of the column headings are long headings for short fields.  We would
like to stack them, but within the same cell.  Is there a character we can
insert that would cause a line break within a cell?  Some that would be
equivalent to when you press Alt-Enter in a spreadsheet cell?


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users