Text to Columns Challenge

[cthurasavin]

Hi, I'm new to Alteryx and I'm hoping to get help from the community on how to split a string of report path with report name. Ideally, you would use Text to Columns tool but in this sample value,

"Main Folder /Sub Folder/This is The Report Name"

How can I easily split "Main Folder/Sub Folder/" from "This is The Report Name" in Alteryx Design?

[Thableaus]

Hi @cthurasavin 

You could use REGEX Parsing with the REGEX Tool:

(.*/)(.*)

Cheers,

[Thableaus · Accepted solution]

Cheers,

[estherb47]

Hi @cthurasavin 

I'd take @Thableaus 's approach, with a Regex parse. You can use the Regex tool, using the Parse method, and that code listed above.

If you'd like to stick with Text to Columns, you can delimit on a "/" into three columns. Then use a formula tool to join the first two columns back together. [A]+"/"+[B], where A and B are the new column names from the Text to Columns tool, should do the trick.

Cheers!

Esther

[DiganP]

@cthurasavin You can use regex, the parse method. 

\>\/(.*)

Attached is the workflow.  

[cthurasavin]

Wow, that is an awesome solution! Thank you!!!

[cthurasavin]

Thanks @EstherB47! I used @Thableaus's approach and it's exactly what I was looking.