Anyway to get a folder name from a string of data like this?
Z:_PROJECTS\client\project\03_3D\01_Scenes\WIP Z:_PROJECTS\client\project\03_3D\01_Scenes\ Z:_PROJECTS\client\project\03_3D\02_Xref
basically I want 'client' and 'project' as fields, they may have a variable number of subfolders after them. I (kind of) know about LEN, but the paths vary in length beyond the bit that I want to extract, so not sure if that'll work very well.
does it always go projects\client\project?
textafter function and textbefore function are your friends here.
@Polygon started 4 months ago
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
Anyway to get a folder name from a string of data like this?
Z:_PROJECTS\client\project\03_3D\01_Scenes\WIP
Z:_PROJECTS\client\project\03_3D\01_Scenes\
Z:_PROJECTS\client\project\03_3D\02_Xref
basically I want 'client' and 'project' as fields, they may have a variable number of subfolders after them. I (kind of) know about LEN, but the paths vary in length beyond the bit that I want to extract, so not sure if that'll work very well.