Extract a variable from a long string in a collection

[ipoblete]

hello,
how are you? Im trying to extract from this long string that is inside a collection the number 17953 which is this data “imported_id”: “17953” with the tag/label “imported_id”.

any idea?
best regards

[Wemakefuture]

Hello @ipoblete nice to meet you.

If you want to extract directly from the long string, you can use regex. But you can also consider parsing JSON and map directly from there.

Don’t hesitate to contact us if you require further assistance.

//VLAD

[Runcorn]

The long string in question looks like a valid JSON. Try passing it to JSON > ParseJSON module and you should be able to directly map the result i.e imported_id through the mapping menu.