Regex - Multi
Hi,
Will have to extract the value of "ContactUUID" and "AWS_Attempts" from the below message..
However it was repeated multiple times, i tried using regex but not working as expected.
Could you please advise?
{"timestamp":1585824067135,"message":{"Interactions":[{"ContactUUID":"fa163e56-cf52-1eda-9d98-64014c28db91","Timezone":"AEST","FullName":"TT_UAT High_105","MarketingCampaign":"","ContactPhone":"+919786629537","ContactEmail":"high_105@gmail.com","C4CStudentId":50093169,"ContactOrigin":"SAP_C4C_BUPA","ContactID":50093169,"MarketingArea":"IDP_AUS","CampaignID":1474,"CampaignPriority":2,"CampaignPriorityName":"High","TargetGroupUUID":"fa163e56-cf52-1eea-9bfe-f9be2adf898d","AWS_Attempts":3},{"ContactUUID":"fa163e56-cf52-1eda-9d98-46153099db2d","Timezone":"AEST","FullName":"TT_UAT High_102Test","MarketingCampaign":"","ContactPhone":"+919787981122","ContactEmail":"high_102test@gmail.com","C4CStudentId":50093164,"ContactOrigin":"SAP_C4C_BUPA","ContactID":50093164,"MarketingArea":"IDP_AUS","CampaignID":1474,"CampaignPriority":2,"CampaignPriorityName":"High","TargetGroupUUID":"fa163e56-cf52-1eea-9bfe-f9be2adf898d","AWS_Attempts":3},{"ContactUUID":"fa163e56-cf52-1eda-9d98-56d6a647db87","Timezone":"AEST","FullName":"TT_UAT High_10003Test","MarketingCampaign":"","ContactPhone":"+919176768220","ContactEmail":"high_10003test@gmail.com","C4CStudentId":50093167,"ContactOrigin":"SAP_C4C_BUPA","ContactID":50093167,"MarketingArea":"IDP_AUS","CampaignID":1474,"CampaignPriority":2,"CampaignPriorityName":"High","TargetGroupUUID":"fa163e56-cf52-1eea-9bfe-f9be2adf898d","AWS_Attempts":3}],"skill_id":4253792},"requestID":"25d10816-9e78-4530-a5dc-d97122e9eee3"}
-
Hi Yuvaraj,
You can use this regex to pull out the ContactUUID as an example, but proceed it with the multi parameter to capture all of the ContactUUID's that appear in the individual message:
| parse regex "{\"ContactUUID\":\"(?<contactuuid>.*?)\"," multi
./Jay Schwegler
Please sign in to leave a comment.
Comments
3 comments