Delimiter the length of a string by special character

[jplasencia-itp]

Hi guys, 

I'm having some trouble limiting the number of characters in a string. This is a match input example of what I'm looking for:

The field length contains the number of breakdowns "\" I really need to have at the Workflow Path. Noticed that the length is variable I mean I would be "1 or 100" so I'm not completely sure the text to columns tool, where the delimiter or the number of rows is fixed will work.

So this would be the result/output:

 

I'll be waiting for some recommendations that would help me.

Thanks!! Attached an excel file with this example.

[Dynamomo · Accepted solution]

Hi @jplasencia-itp,

Probably not the most efficient solution but here is a quick workflow I came up with.

I have documented each step.  Let me know if you have questions.

[jplasencia-itp]

@Dynamomo thanks it works fine, I have just one question how do you manage to concatenate by \ in the Summarize tool?. Because by default this tool concatenates using ",".

I'll appreciate your answer.

[Dynamomo]

In the Summarize tool, if you click on Workflow Path, you'll see that when you concatenate, you can set the delimiter yourself