Searching for newline or linebreak in a field

Elastic Stack Elasticsearch
1

I (somehow) got some text fields that contain line breaks and/or newlines and I'm having trouble constructing a query to locate these.

I've tried
"query": {
"regexp":{
"user.firstname": "\n"
}
}

and
"query": {
"wildcard": {
"user.firstnam": {
"value": "\n"
}
}
}

It would be nice to locate these records to send in for owner data-cleanup.

I'd appreciate a nudge in the right direction...

-Mike

2

What kind of mapping does user.firstname have? Is it keyword?

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.