Text to columns, separate everything after the 4th "\" from a string

[wonka1234]

Hi,

Is there a way I can separate everything after the 4th "\" from a string?

Ie.  O:\Alteryx\community\2023\nov\20\test would become O:\Alteryx\community\2023\nov ?

Thanks

[ShankerV]

Hi @wonka1234 

Yes, Regex is the best tool to achieve it.

Many thanks

Shanker V

[ShankerV]

Hi @wonka1234 

Another way of doing this, 

Input:

Output:

Shanker V

[gautiergodard]

Hey @wonka1234 

Here is one simple way to achieve this:

[ShankerV]

Hi @wonka1234 

Step 1: Input tool

Step 2: Text to columns tool

Step 3:

[1]+'\'+[2]+'\'+[3]+'\'+[4]+'\'+[5]

Step 4: 

Output:

Many thanks

Shanker V

[ShankerV]

@wonka1234 

Hope my solution worked for you!!!

Many thanks

Shanker V

[DataNath]

Hey @wonka1234 here's one possibility with RegEx that will take everything up until the 5th slash:

((?:[^\\]+[\\]){1,4}[^\\]+)