[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] error while reading a string from a column
- Subject: [sqr-users] error while reading a string from a column
- From: rose kunwar <rosekunwar@yahoo.com>
- Date: Tue, 24 Apr 2007 19:18:59 -0700 (PDT)
- Delivery-date: Tue, 24 Apr 2007 22:21:38 -0400
- Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;b=MHmlTAcGrA0JA8argpAS4WyBivy8e3Q3fCA+WT1wvbj25oHq0KNQaEAtlprTnY1LuZg3rn8q/zWQhfeRjiZIhhtmi8h6KTCdho8gpk2lnGrYy7/+1zDkCw2ltJkaED8w6Jp/G69HqjbDj4GO5TZhcmZbusF0N+VfjxUQgoDp5XA=;
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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
__________________________________________________
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