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