need some help in creating regex

vineela — Fri, 17 Dec 2021 04:03:31 GMT

Hi,

I have few logs with data as shown below..i need to extract them as fields and create chart using those values.can anyone please help me through:
16/Dec/2021:22:20:32 +1100 [qtp1936628443-884] [correlationId=b25d79ca-2b70-4912-93f4-1dc5f58841c8] - 2021-12-16T11:20:32.362,,55955f24-a900-e3a7-e053-071bf40a1f09,,,PDS_ERR_API_GET_0001,API GET Call Failed with HTTP Status Code of 4xx Client Error,400,Bad Request,jbcsjhcjehcihdc

i need to extract the values of "PDS_ERR_API_GET_0001" and "400" and "Bad Request"

Thanks in Advance

Re: need some help in creating regex

johnhuang — Fri, 17 Dec 2021 04:33:02 GMT

Assuming your data is consistent and have the same number of comma seperated fields.

| rex "(?:[^,]*,){5}(?<event_type>[^,]*)\,(?<event_message>[^,]*),(?<event_code>[^,]*),(?<event_status>[^,]*)" | table _time event_type event_message event_code event_status

topic need some help in creating regex in Alerting

need some help in creating regex

Re: need some help in creating regex