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

["Kumar, Rahul" <Rahul_Kumar@adp.com>]

Hi rose,

I just tried pasting this in a csv file 
00001|Mike|Boltan|0005
00020|De-Geneor|Smith|0022
00040|Adam|Hunt|0042

and opened the file with excel ,and for me it is showing the second line
also in one col. Please chk once again.maybe there is some prob while
writing in the file.

Thanks,
Rahul

-----Original Message-----
From: sqr-users-bounces+rahul_kumar=adp.com@sqrug.org
[mailto:sqr-users-bounces+rahul_kumar=adp.com@sqrug.org] On Behalf Of
Knapp, Richard
Sent: Thursday, April 26, 2007 7:58 PM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] RE: error while reading a string from a column


Then you must tell Excel as it is importing the file that the delimiter
is a pipe.

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:21 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

I cannot. I have a requirement to use pipe delimiter. 


----- Original Message ----
From: "Knapp, Richard" <KnappR@umsystem.edu>
To: This list is for discussion about the SQR database reportinglanguage
from Hyperion Solutions. <sqr-users@sqrug.org>
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 <DWhite@drc.com>
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" <Steven.Alexander@sanjoseca.gov>
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.'"
<sqr-users@sqrug.org>
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
-----------------------------------------
This message and any attachments are intended only for the use of
the addressee and may contain information that is privileged and
confidential. If the reader of the message is not the intended
recipient or an authorized representative of the intended
recipient, you are hereby notified that any dissemination of this
communication is strictly prohibited. If you have received this
communication in error, notify the sender immediately by return
email and delete the message and any attachments from your system.


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