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

["White . Denise" <DWhite@drc.com>]

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