Regex find key and value pair in JSON formated string

find json key value pair regex

# PHP / Ruby
# Regex find key and value pair in JSON formated string
# Match 1: Key
# Match 2: Value
# https://regex101.com/r/zR2vU9/4
# http://rubular.com/r/KpF3suIL10
# http://stackoverflow.com/questions/14349889/how-to-use-a-regular-expression-to-extract-json-fields/35129815#35129815

(?:\"|\')(?<key>[^"]*)(?:\"|\')(?=:)(?:\:\s*)(?:\"|\')?(?<value>true|false|[0-9a-zA-Z\+\-\,\.\$]*)

# test string
[
  {
    "_id": "56af331efbeca6240c61b2ca",
    "index": 120000,
    "guid": "bedb2018-c017-429E-b520-696ea3666692",
    "isActive": false,
    "balance": "$2,202,350",
    "object": {
		"name": "am",
		"lastname": "lang"
	}
  }
]

Nice! But if the value is a email, it fails... \@ must be added to the values set

Nice! But if the value is a email, it fails... \@ must be added to the values set

(?i)["'](?<key>[^"]*)["'](?:\:)["'\{\[]?([\r\n]?\t+\")?(?<value>\w(?:[\w!#-'*+\/=?^-~-]\.?)+\w+@(?:(?:\w[a-z\d\-]+\w)\.)+[a-z]{2,10}|true|false|[\w+-,.$]*)(",[\r\n])?(?2)?(?J)(?<value>(?&value))?

Give this a go to:

• Match on email addresses.
• Make it case insensitive.
• Match on multiple values for the same key.