Currently I am trying to split the value of a field (an email) by the '@' in an "Aggregation Based - Data Table" visualization at Kibana, so the expected output for an email field with value firstname.lastname@example.org would be:
- field 1: name
- field 2: domain
I have no access to filebeat, which I guess will be th eassiest way to do it, so I tried to apply a painless like substring script and a processor at Advance settings (the JSON script option within the Visualization), as expected, nothing worked.
It is possible to do such an split at this Kibana visualization (or another one) or I have to go to Logstash?
Thank you in advance!