excel

split by delimeter and take just one part
  =TAKE(DROP(TEXTSPLIT([@FullName],"\"), 0, 6), 1, 1)

  - Split the target into a table where each column is a path segment
  - Drop the first 6 columns
  - Take a single (top leftmost) cell from that table