RE: [sqr-users] Data truncated during update from flat file

["Lynds,Rick" <rlynds@mwdh2o.com>]

UNSTRING is a very literal command.  It will split on the specified
delimiter character regardless of where quote marks make occur in the input
string.  If any of your input fields have the remotest possibility of
containing commas, you may want to use a more sophisticated method of
parsing your flat-file input data.

Rick

-----Original Message-----
From: sqr-users-bounces+rlynds=mwdh2o.com@sqrug.org
[mailto:sqr-users-bounces+rlynds=mwdh2o.com@sqrug.org]On Behalf Of Amber
S
Sent: Tuesday, October 12, 2004 9:19 AM
To: This list is for discussion about the SQR database reporting
language from Hyperion Solutions.
Subject: RE: [sqr-users] Data truncated during update from flat file


Yes, I am using a csv file and also assigning to
variables using the unstring command, there is nothing
in the csv file that should cause this, as I mentioned
earlier, the Show command displays the complete
variable


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