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

