How to parse in RegEx on a doulbe pipe

[ractony7]

Hello Community!

I would like to split the following data in RegEx Parse

Beginning Data

10/12/2019||156

02/05/2021||176

Desired Result

10/12/2019	156
02/05/2021	176

Ideally I want to do this without converting the "double pipe" into a different symbol using the formula tool.  Is this possible?  I am quite new to RegEX.  

Thanks Team!

Tony

[binuacs]

@ractony7 

[binuacs · Accepted solution]

@ractony7 another option using Regex Tokenize

[JarekSkudrzyk · Accepted solution]

@ractony7

Hi,

the options given by @binuacs are great. If you would like, for some reason, to use  RegEx Parse you can use the following:

BTW when constructing RegEx I recommend to use regex101.com - it allows to instantly check whether the expression is doing what you meant it to do.

[EN6924 · Accepted solution]

[ractony7]

All of these worked!  Thanks guys!