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:
>
|
,
Solved! Go to Solution.
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
Nevermind, I didn't realize that I can have multiple delimiter within the tool!
Thanks for your help
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 ";"
Regex would be highly appreciated as I want to understand Regex function more in detail
 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
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |