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