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!
Example 1: Tokenise using [^|]+ (any character except |)
Example 2: Parse using =(.+);