RegEx parse to rows at Double pipe delimiter

Hi, I am trying to parse values that are separated by double pipe '||' delimiter. However, I do not like to parse if there is just one pipe '|' delimiter. For example:
Column A Column B
1 123 || 456 || abc

2                   123 | abc || 456

Expected output-
Column A     Column B
1                   123

1 456

1 abc

2 123 | abc

2 456

Can someone help me out here?

Developer Tools

Regex

Tips and Tricks

Parse

Common Use Cases

Accepted answers

OllieClarke

Hey @sunilmandava

I think the solutions offered by @apathetichell and @atcodedog05 are probably the way to go, but if you did want a RegEx solution then this works:

Tokenise to rows on this

(.+?)(?:\|{2}|$)

capturing everything before either 2 '|' or the end of a line (non-greedy)

All comments

atcodedog05

Hi @sunilmandava

Here is how you can do it. Since text to column considers delimiter mentioned as separate delimiter and not together we need to replace " || " to a single character i am replacing it to "$" and then split to rows on "$"

Workflow:

Hope this helps 🙂

split.yxmd

apathetichell

How about this one?

It first replaces the "||" with a tab and then splits to rows.

double pipe.yxmd

OllieClarke

Hey @sunilmandava

I think the solutions offered by @apathetichell and @atcodedog05 are probably the way to go, but if you did want a RegEx solution then this works:

Tokenise to rows on this

(.+?)(?:\|{2}|$)

capturing everything before either 2 '|' or the end of a line (non-greedy)

atcodedog05

@OllieClarke Neat!! i couldnt warp my head around on how can i make it work using regex. Now i know 🙂 and using {2} was one of the thing i needed but think about 😅

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703