Ben, Normally I would just replace it with a space and leave it at that. What I do not know how to do is to apply said replace before the readLine() function is applied. It would have to be a replace that is conditional, meaning only happens if the CR is found within double quotes. Guess the question is more Java related than anything else.
-- Aaron Rouse http://www.happyhacker.com/ On Tue, 07 Dec 2004 10:12:04 -0500, Ben Doom <[EMAIL PROTECTED]> wrote: > 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 Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:186456 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
