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?
Solved! Go to 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
Thank you - works perfect