RE: [sqr-users] SQR output in Excel

["Ven Garlapati" <VXG@creditacceptance.com>]

Thanks Maria,
It worked like a charm.

Thanks,
Ven Garlapati 
vxg@creditacceptance.com
(248) 353-2700 ext.514


-----Original Message-----
From: Maria Joseph [mailto:Maria.Joseph@anu.edu.au]
Sent: Tuesday, December 10, 2002 4:36 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] SQR output in Excel


We use sqr to produce csv files.  

With the left justification Here's an extract from one where the output 
contained fields that were character, but all numeric, so that by default, 
excel treated them as a number and dropped the leading zero(s).  Report Columns 
ITEM_TYPE, ACAD_ORG, CRSE_ID, CATALOG_NBR, DEPT_ID and PROJECT_ID are all 
examples.  They have the extract equals (=) in the assignment in the sqr.  
That's actually an excel thing, but it works and because excel treats the field 
as character, and left justifies it.  Of course if you need to perform 
calculations on the numbers (if they are true numeric fields) this wouldn't be 
an option.

  ! String handling - accommodate commas and quotes in text fields
  ! ensure leading zeros are output to csv

  let $Course_Descr   = '"'  || &REP.DESCR || '"'
  let $Item_Type      = '="' || &REP.ITEM_TYPE || '"'
  let $ItemType_Descr = '"'  || &REP.DESCR1 || '"'
  let $Acad_Org       = '="' || &REP.ACAD_ORG || '"'
  let $Crse_ID        = '="' || &REP.CRSE_ID || '"'
  let $Catalog_Nbr    = '="' || &REP.CATALOG_NBR || '"'
  let $Dept_ID      = '="' || &REP.DEPTID || '"'
  let $Project_ID     = '="' || &REP.PROJECT_ID || '"'


Maria.



-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of Ven Garlapati
Sent: Tuesday, 10 December 2002 8:32 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] SQR output in Excel


Hi all,

I have a sqr program which produces output in xls file format.  The user wants 
some of the columns to left justified, even though the column values are 
numbers, and the column headings to be bolded.  I could not find much help for 
these from the books I got.  Any help would be appreciated.

Thanks.
Ven


_______________________________________________
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