Hi,
I have some logs like this:
fields ............................................. Location=Location#All Locations#Site#City#E-MY-SIT-00-XYZ#TEST, fields..........................
So I need to extract for example E-MY-SIT-00-XYZ from Location field. The string E-MY-SIT-00-XYZ could be different but the schema is always 1Letter-2letters-3letters-2numbers-3letters. Can you help me to extract the string?
Thank you in advance
Hi @marco_massari11,
if you already extracted the location field, you can restrict the regex to the content of this field instead to the full event.
Then you have to create a regex that matches the rule of your field to extract:
in other words, you have to try something like this:
| rex field=Locatioon "(?<your_field>\w-\w\w-\w\w\w-\d\d-\w\w\w#\w\w\w\w)"
regex that you can test at https://regex101.com/r/esbM8c/1
If you're not sure about the number of digits or letters, you can use the repeter in this way:
| rex field=Location "(?<your_field>\w-\w+-\w+-\d+-\w+#\w+)"
Ciao.
Giuseppe
Hi @marco_massari11,
if you already extracted the location field, you can restrict the regex to the content of this field instead to the full event.
Then you have to create a regex that matches the rule of your field to extract:
in other words, you have to try something like this:
| rex field=Locatioon "(?<your_field>\w-\w\w-\w\w\w-\d\d-\w\w\w#\w\w\w\w)"
regex that you can test at https://regex101.com/r/esbM8c/1
If you're not sure about the number of digits or letters, you can use the repeter in this way:
| rex field=Location "(?<your_field>\w-\w+-\w+-\d+-\w+#\w+)"
Ciao.
Giuseppe