Use Regex to delimit a cell to different columns

[Gamaliel]

Hello,

How can I delimit 20130421,20201230|Rodrigo R. Duterte, 06-30-2021 to create the following:

Thank you.

[DawnDuong · Accepted solution]

Hi @Gamaliel 

you can do this with a single Text to column tool by setting multiple delimiters 

,|

as to the formatting of the date field, you can use The Datetime tool to convert string to date and then to the required string format.

dawn 

[Gamaliel]

Massive thanks Dawn