search for newline

Classic Servoy
1

Is it possible to search for newline in Servoy ?

I have a textarea containing several lines :

dog catch
cat run
cow milk

i want to search for records that have a word ( for instance ‘cat’ ) that is at the beginning of the textarea or after a newline in a textarea.

so in the example the record should be found because cat is on the second line after a newline.

Regards,

2

\n is the newLine character on which you can search.

Paul

3

Hi Paul,

Already tryed that.

How do you enter the searchcriteria if you look for the word ‘cat’ after a newline in a textarea ?

%\ncat% doe not return any results

Regards,

4

Have you tried %\ncat%?

I was assuming you were just doing a textsearch in a string in scripting, but I think you are doing a search in the database, right?

What is the syntax Oracle uses to get that result?

Paul

5

tryed \ no success.

And yes, i do the query by entering searchcriteria in a form in a textarea.

Oracle uses chr(10) and has (as far as i know) no escape character for a newline

Regards,