Finding words

Classic Servoy
1

Hi,

I like to find words in a textarea.
When the user enters ~word in a text area and the does a search i replace the text (using regex) by : ‘#word%’ || ‘#% word%’

so i will find all records that have a field with the word “word” in it.

it will find textarea with

Word is in a

or with

this is a word

but it will not find (because it is not at the start of the text and there is no space in front of it)

this is a 
word

Is there a way to search (in Servoy) on word ??

In Oracle sql it would be something like : where upper() like upper(‘word%’) or upper(field) like upper(‘% word%’ ) or upper(field) like ‘%’||chr(10)||‘word%’

Is there a way to search on a carriage return in servoy ??

Regards,

2

Hi Hans,

Perhaps ‘#%\rword’ ? (or \n)

3

Thanks Robert,

But it does not work.

It has to be something that a user could also type into the textarea to find a carriage return.

Regards,