Extract number sequence

[gonhaddock]

Hello @simonmng

@simonmng

{“rel”: “self”, “href”: “https://.net/api/report/eExecution/12345678”}]{ “rel”: “self”, “href”: “https://oup.net/api/ret/cution/12345677”}]

It seems to me that the structure of a JSON file is not standard, the square brackets correlation is missed; besides that, there’s a comma missed in the group separation… the structure should be like this (being aware of quotation type):

[{"rel": "self", "href": "https://.net/api/report/eExecution/12345678"}, { "rel": "self", "href": "https://oup.net/api/ret/cution/12345677"}]

Take a look in this post:

JSON Reader - doesn't read all the data.

Hello @spiltan I went back to your first JSON sample aiming to identify the error. And there’s a lack of format in your processing when generating the file. There are two things to take into account: The first one is about quota encoding, however it can be from my side when copy paste from the chat. There are two type of quotation types “data” <> "data". Just check it. It’s a good use to select preformatted text from the upper ribbon ‘</>’ when pasting code in the chat. The second one …

Then a standard JSON extract workflow can be applied. You should check your data gathering process about why this is happening…

20240903_extract number sequence_v00.knwf (10.4 KB)

BR

PS.- Then you can use String Manipulation vs your latest column:

regexReplace($hrefs$, ".*?(\\d+)", "$1")