How to replace and correct json path string with regex?

Question

I have a javascript array of strings, with modified json path just, like this:

55-fathers-2-married
55-fathers-2-name
55-fathers-2-sons
55-fathers-1-id
55-fathers-1-married
55-fathers-1-name
55-fathers-1-daughters2-2-age
55-fathers-1-daughters2-2-name
55-fathers-1-daughters2-1-age
55-fathers-1-daughters2-1-name
55-fathers-1-daughters2-0-age
55-fathers-1-daughters2-0-name
55-fathers-1-sons-0
55-fathers-1-sons-1
55-fathers-1-sons-2
55-fathers-0-id-somethingelse

How can i change all elements from this list, to become a valid json path ? I mean something like this :

[55].fathers[2].married
[55].fathers[2].name
[55].fathers[2].sons
[55].fathers[1].id
[55].fathers[1].married
[55].fathers[1].name             
[55].fathers[1].daughters2[2].age
[55].fathers[1].daughters2[2].name
[55].fathers[1].daughters2[1].age
[55].fathers[1].daughters2[1].name
[55].fathers[1].daughters2[0].age
[55].fathers[1].daughters2[0].name
[55].fathers[1].sons[0]
[55].fathers[1].sons[1]
[55].fathers[1].sons[2]
[55].fathers[0].id.somethingelse

David Sherret · Accepted Answer · 2013-07-22 20:22:27Z

1

json.replace(/-/g, '.').replace(/(^|\.)([0-9]+)($|\.)/g, '[$2]$3');

Replace the dashes with periods
Search for all numbers within periods or at the beginning or end of a line. Surround those results with brackets. Then add the period ($3) after the bracket if necessary.

edited Jul 22, 2013 at 20:22

answered Jul 22, 2013 at 20:04

David Sherret

108k28 gold badges197 silver badges190 bronze badges

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

4 Comments

user428517 Over a year ago

beautiful regex, could use some explanation for those not very familiar with regexes though

David Sherret Over a year ago

Yeah sorry, I got dragged away from my computer temporarily.

user1538560 Over a year ago

i ran the code, that was almost there, its missing a '.' after ']' .. it should be [55].fathers[2].married not [55]fathers[2]married

David Sherret Over a year ago

Right you are. Didn't notice that. Updated.

Evan Borden · Accepted Answer · 2013-07-22 20:07:08Z

0

You could do something like this:

str.replace(/([a-z]+)/gi, ".$1").replace(/(\d+)/gi, "[$1]").replace(/-/g, '');

answered Jul 22, 2013 at 20:07

Evan Borden

2911 silver badge4 bronze badges

1 Comment

user1538560 Over a year ago

did not work when a field had a number between it. Ex: "55-multivalorado-1-data45-0" became ->> "[55].multivalorado[1].data[45][0]"

Collectives™ on Stack Overflow

How to replace and correct json path string with regex?

2 Answers 2

4 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related