Thanks for your help

from right to left, save two sub directories before the filename, but then remove the second subdirectory is the correct rule

With the the examples:

'\\axis552\ABCS$\File_Provs\Anderson_Company\837\X0102022005009253218.TXT'

'\\axis552\ABCS$\File_Provs\Franks_Company\9422\X0102022005009253218.TXT'

'\\ABCS$\File_ProvsBAK\Lowells_Company\subdir\Lowells_Company\X0102022005009253218.TXT'

I need

Anderson_Company\X0102022005009253218.TXT

Franks_Company\X0102022005009253218.TXT

Lowells_Company\X0102022005009253218.TXT

The file is always in this format with a variable number of characters between the '\'.

The results is a column for a client report and the client doesn't want the...

Thanks

Thanks for your help

Data update