I would do a replace on each text zone, replacing the CR with something 
untypable and ignored by the DB (I usually use the bell, chr(7), but 
choose what you like).  You could then either replace on export or use a 
DB replace function (I'm not familiar with Oracle, but I'm sure it has 
one) to revert the text to the original form.

HTH.

--Ben

Aaron Rouse wrote:
> I have a CSV file that I need to build a web interface for uploading
> into our Oracle database.  One of the things I noticed is this data
> has a CR within it, such as blah,1,12042004,"this has a CR right
> here[]and then more text",blahblah,45 ... and each line ends with a
> CR.  I was wanting to use some of the methods(java.io.StringReader and
> java.io.BufferedReader) that I have seen posted on the list recently,
> just to learn another way but these CRs are throwing things off.  Best
> I can tell the readLine() function that is part of the BufferedReader
> gets to that CR that is with double quotes and sees it as a new line. 
> Would there be some way to make it overlook this?


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186452
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Reply via email to