topic Re: Extract string from between two other strings in Workato Pros Discussion Board

Extract string from between two other strings

klandry — Thu, 22 Feb 2024 17:58:55 GMT

In a recipe, there is an error that is being returned in a datapill from an API call.
I want to extract just the error "text".

Here is a snippet of the string that is being returned:

,\"ErrorMessage\":\"Item KL65512 is not valid\",

I want to end up with:
Item KL65512 is not valid

I was looking at .scan, but I cannot seem to get the correct syntax to achieve what I am looking for.
Any help is appreciated.

Re: Extract string from between two other strings

gary1 — Thu, 22 Feb 2024 18:11:59 GMT

This will work with the snippet provided, but without knowing the rest of the string I can't promise it will always work.

message.scan(/\"ErrorMessage\\\":\\\"(.*?)\\\",/)

I recommend parsing the API response instead, so this comes across as an actual data pill.

Re: Extract string from between two other strings

klandry — Thu, 22 Feb 2024 18:33:44 GMT

Thank you Gary. The snippet that I provided is unique in the string so I avoided posting the entire string.
I had gotten close to what you are suggesting and both seem to product the desired outcome.
.scan(/ErrorMessage\\\"\:\\\"([^\"]+)\\\"/)

The API response is available in the form of a datapill, but I could not find a way to get just that text without REGEX.

Thank You