3

I'm trying to filter features in a QGIS layer to those with the following in their "description" attribute.

<td>CC_W</td>

<td>3</td>

I think what I need is something like this, with the appropriate escape sequences replacing LINEBREAK,LINEBREAK:

"description" LIKE '%CC_W</td>LINEBREAK,LINEBREAK<td>3%'

I've tried \r and \n to no avail. Both of them generate no filter hits even when I search them alone over my feature set, which definitely does have line breaks in the "description" attributes.

"description" LIKE '%\r%' 0 hits

"description" LIKE '%\n%' 0 hits

3
  • Tilde doesn't work. "description" LIKE '%~%' 0 hits. Sep 8, 2020 at 19:49
  • I got a parse error for that. "description" ~ '%\n%' Sep 8, 2020 at 20:09
  • txt LIKE '%\n%' works for me, after copy-pasting the sample data from the question
    – JGH
    Sep 8, 2020 at 20:28

1 Answer 1

1

Try this expression "description" ~ '\n'

example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.