[sqr-users] Excel Formating 2000

["p satheesh kumar" <sathkumar_p@rediffmail.com>]

Hello,

I am doing integration from coldfusion to cgi and in cgi I am forming the sqr 
command and executing the same and creating the .csv file. What my problem is 
the comma seperated value(.csv) is able to open. When I am opening in Excel 
2003 the formatting looks good. I mean all the comma is seperated with new 
column and results is displaying in each and every column in good manner.

When I tried the same in Excel 2000. The results are coming in only one cell. ( 
I mean with comma as a seperator. It is not showing in different cell instead 
it is displaying with comma in only one cell e.g Microsoft Technologies, AL, 
Alabama).

The code I used for forming and executing the sqr command is
$sqrcommand1 =
          "sqrt $Rptsqr $UIDPWD -E$ErrorFile -F$FileName -PRINTER:EP -EH_CSV ".
              " ". "$QUERY_ID" ." ". " ".           
              "\'". "$CLIENT_ID" ."\'". " ".           
              " ". "$ID" ." ". " ".
              "\'". "$PARAMETER1" ."\'". " ".
              "\'". "$PARAMETER2" ."\'". " ".
              "\'". "$PARAMETER3" ."\'". " ".
              "\'". "$PARAMETER4" ."\'". " ".
             " 1>/var/tmp/lm 2>/var/tmp/lm1" ; 

Could somebody help me out.

Thanks in advance,
Satheesh.

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