Trying to split string with formula or Regex

[Carlyn]

Hi

I am trying to create a column which shows the sheet names from a file that has multiple sheets. My workflow is using a macro and it pulls thru the data fine and I have a column with filename. I have got stuck when trying to parse the filename so it gives me the sheet name in a new column. I have tried formulas and now thinking RegEx might be the solution, but I can't seem to get it to provide what I need.

Ideally, the solution will parse the string after the ||| 

I have attached a workflow with an extract showing what I am trying to do. 

Can someone please tell me where I am going wrong?

[OllieClarke · Accepted solution]

Hi @Carlyn 

this regex will parse everything after the final |

.+\|(.+)

the ".+\|" is 1 or more of any character up until the last | you find (being escaped as \|)
then the "(.+)" will capture everything after that.

You can put this in a RegEx tool in parse mode

Hope that helps,

Ollie

[Carlyn]

Thank you - works perfect