RE: [sqr-users] RE: error while reading a string from a column

[ashwin reddy <ashwin443@yahoo.co.uk>]

change the delimiter in Excel to Pipe "|" nd shuld be able to see the file in 
the right way
   
  go to Control panel > Regional & lang settings > in  Regional Options Tab 
"Click the Customuze button" and change the list seperator to "|"
   
  The format u got inside the file is correct its only the way excel interprets 
the delimiter its showing the file in such a way .....
   
  Mahesh 

Larry Roux <lroux@syr.edu> wrote:
  Same here. I just tested your sample and it came up fine when I told
Excel that the delimiter character was |

-----Original Message-----
From: sqr-users-bounces+lroux=syr.edu@sqrug.org
[mailto:sqr-users-bounces+lroux=syr.edu@sqrug.org] On Behalf Of Tajinder
Chahal
Sent: Thursday, April 26, 2007 10:29 AM
To: sqr-users@sqrug.org; rosekunwar@yahoo.com
Subject: Re: [sqr-users] RE: error while reading a string from a column

When you open the file in Excel, in one of the steps it asks what kind
of 'Delimiter' you are using. Specify '|' in the 'Other' field.
It works fine for me.

>>> rosekunwar@yahoo.com 04/26/07 10:20AM >>>
I cannot. I have a requirement to use pipe delimiter. 


----- Original Message ----
From: "Knapp, Richard" 
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions. 
Sent: Thursday, April 26, 2007 10:17:50 AM
Subject: RE: [sqr-users] RE: error while reading a string from a column


Rose,

CSV stands for comma separated values. Replace the pipes with commas.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu 


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
rose kunwar
Sent: Thursday, April 26, 2007 9:11 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Subject: Re: [sqr-users] RE: error while reading a string from a column

Here is what my .csv file looks like

00001|Mike|Boltan|0005
00020|De-Geneor|Smith|0022
00040|Adam|Hunt|0042

But when I open this .csv file with Excel, it thinks that hyphen is
delimiter. So instead of showing entire row in one column (for second
row in above example), it shows "00020|De" in column and
"Geneor|Smith|0042" in another column. And the hyphen in the firstname
is missing. 

So I was wondering if the problem is associate with reading the data or
writing the data. 
Or may be it is because of Excel itself because if I open same .csv file
through notepad, it is showing me as the one above.






----- Original Message ----
From: White . Denise 
To: sqr-users@sqrug.org 
Sent: Thursday, April 26, 2007 9:23:47 AM
Subject: [sqr-users] RE: error while reading a string from a column


Yes, you need to tell us more specifically what the problem is. Reading
and writing fields with commas and hyphens should be no problem; I have
done it frequently, especially with the name field. A string is a
string.

Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
------------------------------

Message: 2
Date: Wed, 25 Apr 2007 10:24:15 -0700
From: "Alexander, Steven" 
Subject: RE: [sqr-users] error while reading a string from a column
To: "'This list is for discussion about the SQR database
reportinglanguage from Hyperion Solutions.'"

Message-ID:

<62AFC819CCF3D611827A00065B3F7981101F989D@sj_exchange.sjcity.net>
Content-Type: text/plain

What do you mean "I am not able to read it as single string"? Are you
saying there is a problem in the begin-select statement? What happens
when you try to read it?

-----Original Message-----
From: sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org 
[mailto:sqr-users-bounces+steven.alexander=sanjoseca.gov@sqrug.org] On
Behalf Of Knapp, Richard
Sent: Wednesday, April 25, 2007 7:33 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] error while reading a string from a column


Maybe translate will work for you.

Richard Knapp
EAS - Data Warehouse Group
University of Missouri
615 Locust Street #200
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu 


-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org 
[mailto:sqr-users-bounces+knappr=umsystem.edu@sqrug.org] On Behalf Of
rose kunwar
Sent: Tuesday, April 24, 2007 9:19 PM
To: sqr-users@sqrug.org 
Subject: [sqr-users] error while reading a string from a column

Hi all,

How do I read a string with special characters (like comma) Here is what
I am trying to do.
|
|
open 1 for writing....... 

Begin-select
a.emplid
a.first_name
move &a.emplid to $emplid
move &a.first_name to $firstname
from ps_personal_data.
|
|
|
write 1 from
$emplid '|'
$firstname '|'
|
|
The result should be like this:
01|jack|
02|mike|
|
|
but
if $firstname has hyphen, then I am not able to read it as single
string, so that I can write that value within same delimiter. Please
help...kind of urgent

Rose

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

__________________________________________________
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 

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

__________________________________________________
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

_______________________________________________
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


       
---------------------------------
 Yahoo! Answers - Got a question? Someone out there knows the answer. Tryit now.

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