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

["Knapp, Richard" <KnappR@umsystem.edu>]

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