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

["franck\.masson2002" <franck.masson2002@laposte.net>]

have you tried to add <<">> around your value
today
00001|Mike|Boltan|0005
proposed
"00001"|"Mike"|"Boltan"|"0005"

regards

> change the delimiter in Excel to Pipe "|" nd shuld be able to see the file in 
>the right way
>
>   go to Control panel > Regional & lang settings > in  Regional Options Tab 
>"Click the Customuze button" and change the list seperator to "|"
>
>   The format u got inside the file is correct its only the way excel 
>interprets the delimiter its showing the file in such a way .....
>
>   Mahesh
>
> Larry Roux <lroux@syr.edu> wrote:
>   Same here. I just tested your sample and it came up fine when I told
> Excel that the delimiter character was |
>
> -----Original Message-----
> From: sqr-users-bounces+lroux=syr.edu@sqrug.org
> [mailto:sqr-users-bounces+lroux=syr.edu@sqrug.org] On Behalf Of Tajinder
> Chahal
> Sent: Thursday, April 26, 2007 10:29 AM
> To: sqr-users@sqrug.org; rosekunwar@yahoo.com
> Subject: Re: [sqr-users] RE: error while reading a string from a column
>
> When you open the file in Excel, in one of the steps it asks what kind
> of 'Delimiter' you are using. Specify '|' in the 'Other' field.
> It works fine for me.
>
> >>> rosekunwar@yahoo.com 04/26/07 10:20AM >>>
> I cannot. I have a requirement to use pipe delimiter.
>
>
> ----- Original Message ----
> From: "Knapp, Richard"
> To: This list is for discussion about the SQR database reportinglanguage
> from Hyperion Solutions.
> 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
> 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"
> 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.'"
>
> 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
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
>
>
>
> ---------------------------------
>  Yahoo! Answers - Got a question? Someone out there knows the answer. Tryit 
>now.
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
> 

Créez votre adresse électronique prenom.nom@laposte.net
1 Go d'espace de stockage, anti-spam et anti-virus intégrés.


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