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

["Paul Hoyte" <pi_hoyte@si-proservices.com>]

Or you can change the delimiter if you use the customize button under the 
regional and language settings in the windows control panel to what ever you 
want, and then Excel will recognize it as the "official" delimiter and open the 
file correctly.  But, as there's always a but with WIndows, this change will 
then be applied to all Windows apps that use delimiters, Access for example.

>----- ------- Original Message ------- -----
>From: "Don Simpson" <don.12ocr@blueyonder.co.uk>
>To: "This list is for discussion about the SQR
>database reportinglanguage from
>        Hyperion Solutions." <sqr-users@sqrug.org>
>Sent: Thu, 26 Apr 2007 17:51:58
>
>Hi, Rose and all the other contributors.
>
>I think you're working with "mixed messages". As
>has been stated, csv is a
>particular file type and Excel is set up to
>recognise it, I'll bet your file
>has an Excel type icon against it, yes? What will
>happen, then, is if you
>double-click the file to open it, Excel expects it
>to be comma separated,
>and hence you get your problem. I would be tempted
>to advise whoever has
>stated the requirement to be a pipe-delimited csv
>file that they are wrong
>in doing so, 'cause it's going to confuse the hell
>out of Both Excel and
>your users of the file. Call it a .txt file and get
>it into Excel by opening
>Excel from the desktop, then "File/Open" the file.
>You'll then get the
>dialogue that other contributors have spoken about
>and you can tell the
>dialogue to use pipe as the delimiter. If your
>requirement authority wants
>an automatic "double-click" open of the file for
>the users, then you can't,
>I think, successfully use the pipe, you'll have to
>produce proper comma
>separators. HOWEVER, you now need to ensure you
>have no commas inside your
>data fields or it all goes pear-shaped. If you
>have, then you'll have to add
>double-quotes to both ends of any data that has a
>comma in it.
>
>Regards,
>
>Don (a different one!!)
>
>-----Original Message-----
>From:
>sqr-users-bounces+don.12ocr=blueyonder.co.uk@sqrug.
>org
>[mailto:sqr-users-bounces+don.12ocr=blueyonder.co.u
>k@sqrug.org]On Behalf
>Of don.barclay@srs.gov
>Sent: 26 April 2007 17:03
>To: This list is for discussion about the SQR
>database reporting
>languagefrom Hyperion Solutions.
>Subject: [sqr-users] RE: error while reading a
>string from a column
>
>
>Hi Rose,
>
>We might be making this too complicated.  The user
>has asked that you
>create a CSV file using pipes as delimiters.  You
>are creating that per
>their requirements as you have proven by opening
>the file in notepad.  Is
>the user having any problems opening the file in
>Excel per their own
>requirements?  If not -- you're done!
>
>Don
>
>> > >>> rosekunwar@yahoo.com 04/26/07 10:20AM >>>
>> > I cannot. I have a requirement to use pipe
>delimiter.
>
>_______________________________________________
>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