Hello,
I have requirement where I have to parse a sub folder name from another input and select the path until that sub folder.
in row 2 I have to select path until sub folder Tree "C:\Users\Tree\"
in row 3 I have to select path until sub folder Egg Plant "C:\Users\Tree\Vegetable\Egg plant\"
Thanks in Advance
Solved! Go to Solution.
A different way to get there might be:
LEFT([directory], Findstring([Directory],[Sub Folder])+length([Sub Folder])
1 2 3 01234567890123456789012345678901234567890 ----+----|-----+----|----+----|----+----|
C:\Users\Tree\Vegetable\Egg Plant\Tall
Egg plant is found and should return: 24
Length of Egg plant is 9
That's 0-based and if you say LEFT(FIELD, 33) then it should be about right.
Cheers,
Mark
Hi Mark,
It works like a charm when I use left function to get the path until that sub folder.
But when I try to use Right function to select a relative path to shorten my path it is not working. Is there a different work around..?
i'm not in front of alteryx.....
Does that make sense? There is likely an easier way, but this seems easiest to type on my phone.
Cheers,
Mark
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |