Filter the logs based on Last character in Kibana

Hi Team,

I want to Filter the logs based on RobotName(Field) last character.Can anyone help me out for Editing the query of the filter in kibana.

Eg: RobotName(field): 123a,234a,345b,345b

Based on last character "a"
Required o/p : 123a,234a,345a

Hello @lukas_krishnan

How is the data being ingested? Could you create a new field with just that character?

Have you tried using a kibana scripted field? https://www.elastic.co/guide/en/kibana/current/scripted-fields.html