Trying to extract specific information from a string

InsightConnect
1

Hi there,

what’s the easiest way to extract information out of a given string. Let’s say I have the following string:

...CountryCodes: GB, IT, NL, URL: https://alert.abc.com/?customer=ab&result_id=9956357&type=appsearch, First Seen: 2021-11-15,....

I’d like to extract the id which is between “result_id=” and “&type=appsearch”

2

use a parse step

result_id={{result_id:/\d+/}}&type={{type:/[^,]+/}}

3

Do you mean a Pattern Match Step? I was trying to do that with your query as a pattern, but it doesn’t match. Edit: When I just use result_id={{result_id:/\d+/}} as a pattern, it works :slight_smile:

4

yes, Pattern Match Step.
I think my pattern was missing a / at the end, it also might need tweaked based on your data, but the concept should work.

1 Like