
Announcements
Hi All,
I'd like to know the simplest way to count how many times a / appears in different strings e.g. :
/Folder/Folder2/Folder3/Folder4
/Folder/Folder2/Folder3/Folder4/Folder5/Folder6
/Folder/Folder2/Folder3/Folder4/Folder5
/Folder/Folder2/Folder3/Folder4/Folder5/Folder6/Folder7/Folder8
Thanks in advance
I have figured it out by using this expression :
length(split(variables('FilePath'),'/'))
It splits the text into sections where the / is and then counts the splits. So I end up with
/Folder/Folder2/Folder3/Folder4 = 4 sections
/Folder/Folder2/Folder3/Folder4/Folder5/Folder6 = 6 sections
/Folder/Folder2/Folder3/Folder4/Folder5 = 5 sections
/Folder/Folder2/Folder3/Folder4/Folder5/Folder6/Folder7/Folder8 = 8 sections