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

["Don Simpson" <don.12ocr@blueyonder.co.uk>]

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.uk@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