RE: [sqr-users] SQR output in .csv file

[Roger.Harris@certegy.com]

A "csv" file will NOT open or save with any formatting. The other option
that you have is to create your file in a SYLK (*.slk) format with which
you can apply basic formatting options including data types of columns.
There have been a number of threads in this issue, search the archives for
"slk".



|---------+---------------------------------------------------->
|         |           "Bob Buford" <Bob.Buford@ccci.org>       |
|         |           Sent by:                                 |
|         |           sqr-users-bounces+roger.harris=certegy.co|
|         |           m@sqrug.org                              |
|         |                                                    |
|         |                                                    |
|         |           09/06/2005 08:59 AM                      |
|         |           Please respond to "This list is for      |
|         |           discussion about the SQR database        |
|         |           reporting  language from Hyperion        |
|         |           Solutions."                              |
|         |                                                    |
|---------+---------------------------------------------------->
  
>----------------------------------------------------------------------------------------------|
  |                                                                             
                 |
  |        To:      "This list is for discussion about the SQR database 
reportinglanguage from   |
  |        Hyperion Solutions." <sqr-users@sqrug.org>                           
                 |
  |        cc:                                                                  
                 |
  |        Subject: RE: [sqr-users] SQR output in .csv file                     
                 |
  
>----------------------------------------------------------------------------------------------|



Hi Srikanth,

I suggest using tab as your field delimiter rather than comma.  It is
interpreting the comma in your value as a field delimiter - so use a
different delimiter.  Excel works just as well recognizing Tab for
field, Carriage Return (chr 13) as record, as it would with comma.

As to your second question (how to preset formatting for a cell so as to
show 3 significant digits even with trailing zeros), I don't know the
answer, but you should look in help references to see how to preset
formatting so that a csv file will open with preferred formatting.

BTW, you can output as .xls just as easily as .csv as regards the file
name

I did some research at MS Online here:
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsof
t.public.excel.misc&lang=en&cr=US

It appears that the stripping happens when you open the .csv file.  You
could try renaming file as .xls and see if this happens.



Bob Buford

-----Original Message-----
From: srikanth reddy [mailto:srikanthreddy_mca@yahoo.com]
Sent: Tuesday, September 06, 2005 4:48 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] SQR output in .csv file


Hello ,

    The user is expecting to open the CSV file in Excel just on Double
click and not by using any Wizard. So I have to use comma as the
seperator .

Can you suggest any other solution for the following problem.

 if the Output I want to display is 3,456.234 then in the Excel file 3
is being displayed in one column and 456.234 is being displayed in
another column.
Point to be noted is I have used the technique like '=" || xyz || '"'
where xyz contains the value but still the output is splitted into two
different coulmns in the excel file.


if we use the mask as $$$$$$$$$9.99 then value is displayed properly
i.e. like $10,000.50

Example MOVE #amt TO $amount $$$$$$$$9.99

But if we use the mask as 999999999.99999 then comma is not displayed

Ex : MOVE #amt TO $amount 99999999.99 then only 23456.98 is displayed.

If we use MOVE #amt TO $amount  999,999,999.99 then value is splitted
into different cells in excel

ex 23 is displayed in one column and 456.98 is displayed in another
coulmn,

But I want 23,456.98 to be displayed only in one column,

Please suggest a solution.

Thanks
Srikanth





Sam Spritzer <teknogeek9@yahoo.com> wrote: (i) Instead of using a comma
as a separator, use a semi-colon (;).
(ii) when you are importing into Excel, use the Text Import Wizard. The
third step of that feature allows you to define how you want a specific
column to be formatted. In your case, you would want TEXT.
SQRly yours,
Sam

srikanth reddy wrote:
Hello ,
I am having a two issues while displaying values in the .csv format .

(i) if the Output I want to display is 3,456.234 then in the Excel file
3 is being displayed in one column and 456.234 is being displayed in
another column.
Point to be noted is I have used the technique like '=" || xyz || '"'
where xyz contains the value but still the output is splitted into two
different coulmns in the excel file.

(ii) if the output i want to display is 23.450 then only 23.45 is
displayed in the Excel file. i.e. trailing zero is not displayed.

Can you please suggest a solution for this.

Thanks
Srikanth



---------------------------------
Click here to donate to the Hurricane Katrina relief effort.

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


************************************************************
"In the beginning, there was something...which exploded yet, they find
nothing."
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

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



---------------------------------
 Click here to donate to the Hurricane Katrina relief effort.



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









------------------------------------------------------------------------------
This message contains information from Certegy, Inc which may be confidential 
and privileged.  If you are not an intended recipient, please refrain from any 
disclosure, copying, distribution or use of this information and note that such 
actions are prohibited.  If you have received this transmission in error, 
please notify by e:mail postmaster@certegy.com.
==============================================================================


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