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
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
Hey @wonka1234 here's one possibility with RegEx that will take everything up until the 5th slash:
((?:[^\\]+[\\]){1,4}[^\\]+)