Extract string using regex parsing

[Tycho]

Dear community,

I'm trying to extract a segment of a string. I've searched the forum for different solutions but so far can't get it to work.

Below you see an example of a string i'm working on.

Example 1:

aka:EMEAOds|||MARM + aka:EMEAOds|||CUSTOMER + aka:EMEAOds|||PRICELIST + aka:EMEAOds|||KONM + aka:EMEAOds|||MATPLANT

Example 2:

snowbl:DSN=Snowflake_Inv;UID=###

In example 1 I'm trying to extract all characters between the "|||" (3 pipelines).

In example 2 im trying to extract all characters between "=" and ";"

So far no luck yet..

Any help would be greatly appreciated. Thank you in advance!

[Christina_H]

Example 1: Tokenise using [^|]+ (any character except |)

Example 2: Parse using =(.+);