You are reading a single comment by @Polygon and its replies. Click here to read the full conversation.
  • 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.

About

Avatar for Polygon @Polygon started