Need help in extracting certain information from a cell

This is a litte complicated for my level. Hopefully someone here has a solution to this.


Original data in cell A1:
[{"attribution_url":"fs.com","original_picture_url":"fs.com/attachments/product_template_additional_pictures/images/001/200/345/original/1.jpg?1234","source_url":"fs.com/collections/fsabc/products/fsabc"},{"attribution_url":"fs.com","original_picture_url":"fs.com/attachments/product_template_additional_pictures/images/002/300/456/original/2.jpg?2345","source_url":"fs.com/collections/fsbcd/products/fsbcd"},{"attribution_url":"fs.com","original_picture_url":"fs.com/attachments/product_template_additional_pictures/images/003/400/567/original/3.jpg?3456","source_url":"fs.com/collections/fscdf/products/fscdf"},

Desired data in a cell (only for :"original_picture_url"):

Cell B1: fs.com/attachments/product_template_additional_pictures/images/001/200/345/original/1.jpg?1234
Cell C: fs.com/attachments/product_template_additional_pictures/images/002/300/456/original/2.jpg?2345
Cell D1: fs.com/attachments/product_template_additional_pictures/images/003/400/567/original/3.jpg?3456

Would like to achieve something like this but I'm not sure how after trying to search some solutions online. Hopefully you can help me out. Thank you in advance!

Attach a sample workbook showing your original data and your desired outcome. It will make it much easier for us to understand the requirement.

BSB

Hi

Sorry for the length of the formula.

The formula uses the 1000-character limit that may be in the original cell. This value can be magnified, but the higher this value, the longer it takes to calculate it.

Consider A2 as the source cell. Put the following formula in B2 and drag it forward.

Formula:

=IFERROR(MID($A2,

AGGREGATE(15,6,ROW($A$1:$A$1000)/(MID($A2,ROW($A$1:$A$1000),10)="fs.com/att"),COLUMNS($B$1:B$1)),

AGGREGATE(15,6,ROW($A$1:$A$1000)/(MID($A2,ROW($A$1:$A$1000),1)="?"),COLUMNS($B$1:B$1))-

AGGREGATE(15,6,ROW($A$1:$A$1000)/(MID($A2,ROW($A$1:$A$1000),10)="fs.com/att"),COLUMNS($B$1:B$1))+5),"")

See the file