Regex to extract string between different delimiters (Tokenize)

[fredcolina]

Hi,

I have a log with a field that I would like to Tokenize. I would like a Regex that will split the string in different tokens based on three delimiters that I could have (until now :-))

Basically bring into columns all the string between:

>

|

,

[MarqueeCrew · Accepted solution]

Did you know that you can use the text to columns tool and put all three delimiters into the delimiter field? That seems like the easy answer.

Cheers,

Mark

[fredcolina]

Hi, thanks for your quick reply.

The issue with that path is that I will need to create as many steps in the flows as delimiters no?

I was wondering if I can group a Regex in which I can give the strings (delimiters) to consider and then grab the string after that.

Freddy

[fredcolina]

Nevermind, I didn't realize that I can have multiple delimiter within the tool!

Thanks for your help

[sakshim]

I have a same problem but I want to use this in Formula tool, hence don't wish to create multiple columns just extract the string, I have a substring which is like  '"ACTO": IMPID-452673";" at any place in the sentence. I just need to extract IMPID-452673 (Kindly note the length of numbers can be more or less ). In every sentence, IMPID is followed by ";"  

[sakshim]

Regex would be highly appreciated as I want to understand Regex function more in detail

[dwstada]

 Hey @sakshim 

try this out, it looks for the IMPID and replaces everything in the cell with the found IMPID.

regex parts:

.*? = content can start with anything for as long as necessary

(IMPID-\d+) = find "IMPID-" and any number of digits afterwards, and remember the found string in a capture group

.* = anything can come afterwards

with the regex_replace function, we replace whatever matched the expression with what we specify, and this replaces everything with "$1" which is the first capture group of the expression