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

["Bob Buford" <Bob.Buford@ccci.org>]

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