Re: Find line breaks on different systems

From: Bernhard Graeuler <fuerspam_at_gmx.de>
Date: Fri, 1 Aug 2003 19:09:16 +0200
Message-ID: <bge6rs$nomc2$1@ID-49408.news.uni-berlin.de>

Rauf Sarwar wrote:
> Originally posted by Bernhard Graeuler
>> Hi,
>>
>> Do I have to check all possibilities in my stored procedure or
>> is there another way to do this.
>>
>> Confusing: Im using Windows, so I expected 'CRLF' as line break, but
>> SPLITLINE only works correctly if it searches for 'CR'.
>>
>
> To be safe and OS independent, check separately for both.
>
> IF ( (INSTR(string, CHR(13), 1, 1) != 0) OR
> (INSTR(string, CHR(10), 1, 1) != 0) ) THEN
> .....
> END IF
>

Ok. Thanks. I check for the windows line break before, so there won't be any troubles with extant line break signs.

Regards

Bernhard Received on Fri Aug 01 2003 - 12:09:16 CDT