Regex to mask the JSON Value

Follow

Nagaraju Kshathriya

• August 26, 2020 06:48

HI Team,,

I tried many ways to mask the PII Data by using regex, but Sumo is not accepting normal regex queries.

I want to mask the field if key contains as string. for example,

{

      "primaryEmail" : "abc@domain.com"

}

 

Now i want to mask the value like below

{

      "primaryEmail" : ####

}

 

 

0

• Official comment

  

  Nathan Beltran

  • August 26, 2020 12:58
  • Edited

  Expressions that you want masked must be expressed as a capture group in the regex. Capture groups are identified with enclosed parentheses ().

  Here try this regular expression.

  primaryEmail\" : \"(.*)\"

   

  Comment actions Permalink
• 

  Nagaraju Kshathriya

  • August 26, 2020 13:09

  Thanks a lot @Nathan. sorry my bad actually we may get email address key in different formats. Say

  {
  "PrimaryEmail" : ""abc@domain.com"
  }
  {
  "EmailAddress" : "abc@domain.com"
  }

  {
  "emailAddress" : "abc@domain.com"
  }

  many formats. sometime camelCase and sometimes complete in capitals etc.

  My ultimate goal is to mask the value if key contains "email" or "mail"

  Thanks,
  NaGG

  0

  Comment actions Permalink
• 

  Nathan Beltran

  • August 26, 2020 13:25

  Try this regex. Ive included a noncapture group to match the  email fields.

  (?i:primaryemail|emailaddress)\" : \"(.*)\"

  2

  Comment actions Permalink

Please sign in to leave a comment.