Text to Columns Challenge

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?

Developer Tools

Accepted answers

Thableaus

Cheers,

All comments

Thableaus

Hi @cthurasavin

You could use REGEX Parsing with the REGEX Tool:

(.*/)(.*)

Cheers,

Thableaus

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.

Regex.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703