extracting string from file using powershell

Question

I have a json response from where I need to read only the path name and write to an output file

"path":"path1","url":"URL1"},"changeType":"edit"},{"item":{"version":138390,"size":2209,"hashValue":"CJkHrcI2FSKb3IoIGr/g/g==",
"path":"PATH2","url":"URL2"},"changeType":"edit"},{"item":{"version":138390,"size":25263,"hashValue":"OU0Rf623p47fTt4ASnSGOA=="

and I want my output file to have just PATH1 PATH2

how do i use regex to achieve this? or any other easier way to do this?

Please format your code and sample input/output properly.

mklement0
– mklement0

2020-05-25 02:45:44 +00:00
Commented May 25, 2020 at 2:45 — mklement0
– mklement0, Commented May 25, 2020 at 2:45
Your Json don't seem to be valid.

JPBlanc
– JPBlanc

2020-05-25 04:31:28 +00:00
Commented May 25, 2020 at 4:31 — JPBlanc
– JPBlanc, Commented May 25, 2020 at 4:31
Please edit your question and show us valid json.

Theo
– Theo

2020-05-25 07:43:41 +00:00
Commented May 25, 2020 at 7:43 — Theo
– Theo, Commented May 25, 2020 at 7:43

Prosenjit Sen · Accepted Answer · 2020-05-25 04:14:52Z

1

Please format your json properly and then you may use something like this to get the path value

(Get-Content "<path of json file>" | ConvertFrom-Json).item.path

answered May 25, 2020 at 4:14

Prosenjit Sen

3664 silver badges7 bronze badges

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

Collectives™ on Stack Overflow

extracting string from file using powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related