How would I create a Regex expression to parse a column into separate columns based on ;#

[Hoss2434]

Hello,

I am trying to use Regex to parse text into columns into separate columns based on special characters. Here is an example of the desired output:

Before:

;#Value one;#Value two;#Value three;#

After:

Value one

Value two

Value three

Any help would be appreciated.

Thanks!

[flying008]

Hi, @Hoss2434 

There are 2 ways to get your want:

******

If it can help you , please mark it as a solution and give a like for more share.

[binuacs]

@Hoss2434 One way of doing this with the Regex Tokenize method