Regex - Multi

Follow

Yuvaraj M

• April 02, 2020 13:41

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"}

0

• 

  Jay Schwegler

  • April 02, 2020 21:35
  • Edited

  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

  https://help.sumologic.com/05Search/Search-Query-Language/01-Parse-Operators/02-Parse-Variable-Patterns-Using-Regex#parse-multi

  ./Jay Schwegler

   

   

  0

  Comment actions Permalink
• 

  Yuvaraj M

  • April 03, 2020 07:52

  Thanks Jay, that helped :)

  0

  Comment actions Permalink
• 

  Jay Schwegler

  • April 03, 2020 13:36

  No problem! Glad everything is working.

  ./Jay Schwegler

   

  0

  Comment actions Permalink

Please sign in to leave a comment.