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

["Elvis Pressly" <elvisdman@hotmail.com>]

Rose,

Your csv output is doing fine. It's the way excel reads your input. You have 
to tell excel that pipe is your delimiter. What you can do is make sure your 
output is a text file then open with excel and let excel knows that your 
delimiter is a pipe character.

>From: rose kunwar <rosekunwar@yahoo.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] RE: error while reading a string from a column
>Date: Thu, 26 Apr 2007 07:20:34 -0700 (PDT)
>
>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

_________________________________________________________________
Download Messenger. Join the i’m Initiative. Help make a difference today. 
http://im.live.com/messenger/im/home/?source=TAGHM_APR07


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