PHP Regex extract key-value comma separated [duplicate]

Question

I want to extract some from a string that KEYs are separated from VALUEs by colon(:) and s separated by comma(,). The problem is that VALUEs can contain comma. As an example:

category:information technology, computer,publisher:Elsevier (EV),subject:Ecology, Evolution, Behavior and Systematics

In this example the KEYs that must extract are: category, publisher and subject. The final result must be as follow:

category = information technology, computer
publisher = Elsevier (EV)
subject = Ecology, Evolution, Behavior and Systematics

I tried to write a recursive regex but it doesn't work :

(category|publisher|subject):(.*?)(?:,(?R)|.?)

Can someone help to solve this problem. Thanks.

user372495 · Accepted Answer · 2016-02-19 00:38:53Z

5

Well, if you can add a comma to the end of the string, I think this works:

(\w+):([^:]+),

Edit:

Jonathan Kuhn is totally right:

(\w+):([^:]+)(?:,|$)

This works

edited Feb 19, 2016 at 0:38

answered Feb 19, 2016 at 0:29

user372495

7104 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Jonathan Kuhn Over a year ago

If you replaced the trailing comma with (?:,|$) it would match a comma or the end of the string in a non-grouping match. Eliminating the need to add a comma to the end of the string. regex101.com/r/gG9kF3/1

M Sh Over a year ago

Thanks. this regex works correctly but can you analyse below regex that also works : (\b\w+):(.*?(?=,\w+:|$))

Collectives™ on Stack Overflow

PHP Regex extract key-value comma separated [duplicate]

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related