Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Trying to split string with formula or Regex

Carlyn
8 - Asteroid

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?

2 REPLIES 2
OllieClarke
15 - Aurora
15 - Aurora

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
8 - Asteroid

Thank you - works perfect

Labels
Top Solution Authors