Re: sql statement to find carriage return
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 18 Dec 2003 12:28:58 -0800
Message-ID: <1071779244.356738_at_yasure>
>>Alex Filonov wrote:
>>
>>
>>>"Bill Thomason" <billthomason_at_charter.net> wrote in message news:<vtur8v91iqmi93@corp.supernews.com>...
>>>
>>>
>>>>I am looking for a simple sql statement to find carriage returns in our data
>>>>that has been loaded.
>>>>
>>>>Bill
>>>
>>>
>>>select <whatever you want>
>>>from <your table>
>>>where instr(<column you want to check>, chr(13)) != 0 /* DOS character */
>>> or instr(<column you want to check>, chr(10)) != 0 /* carriage-return */
>>>
>>>Only works with charactersets which are ASCII supersets.
>>
>>You are assuming the field is a CHAR or VARCHAR2. That is only an
>>assumption as the OP never stated the data type. It could be a LONG
>>or a CLOB: We just don't know.
Date: Thu, 18 Dec 2003 12:28:58 -0800
Message-ID: <1071779244.356738_at_yasure>
Alex Filonov wrote:
> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1071701407.299559_at_yasure>... >
>>Alex Filonov wrote:
>>
>>
>>>"Bill Thomason" <billthomason_at_charter.net> wrote in message news:<vtur8v91iqmi93@corp.supernews.com>...
>>>
>>>
>>>>I am looking for a simple sql statement to find carriage returns in our data
>>>>that has been loaded.
>>>>
>>>>Bill
>>>
>>>
>>>select <whatever you want>
>>>from <your table>
>>>where instr(<column you want to check>, chr(13)) != 0 /* DOS character */
>>> or instr(<column you want to check>, chr(10)) != 0 /* carriage-return */
>>>
>>>Only works with charactersets which are ASCII supersets.
>>
>>You are assuming the field is a CHAR or VARCHAR2. That is only an
>>assumption as the OP never stated the data type. It could be a LONG
>>or a CLOB: We just don't know.
> > > As a real programmer, I give incomlete answer in hope that if it doesn't > work, the customer would come back with new questions. :-)
Can you teach me how? ;-)
Oh yeah ... I teach.
Never mind.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Thu Dec 18 2003 - 21:28:58 CET