Thank you marycordova.  This is almost close to what I'm looking for.  But if my data changes to something like: 
 /path1/path2/path3/path4/path5/car_Nam-Cluster_01_201902190559_41795  
/path1/path2/path3/path4/path5/car_Nam-Cluster_02_201902190559_41796  
/path1/path2/path3/path4/path5/car_Nam-Cluster_03_201902190559_41797  
/path1/path2/path3/path4/path5/car_Asia-Cluster_01_201902190559_41795  
/path1/path2/path3/path4/path5/car_Asia-Cluster_02_201902190559_41796  
/path1/path2/path3/path4/path5/car_Asia-Cluster_03_201902190559_41797  
/path1/path2/path3/path4/path5/car_EMEA-Cluster_01_201902190559_41795  
/path1/path2/path3/path4/path5/car_EMEA-Cluster_02_201902190559_41796  
/path1/path2/path3/path4/path5/car_EMEA-Cluster_03_201902190559_41797  
/path1/path2/path3/path4/path5/car_India-Cluster_01_201902190559_41795  
/path1/path2/path3/path4/path5/car_India-Cluster_02_201902190559_41796  
/path1/path2/path3/path4/path5/car_India-Cluster_03_201902190559_41797 
 it only captures, 
 car_Nam-Cluster_01  
car_Nam-Cluster_02  
car_Nam-Cluster_03 
 but not, 
 car_Asia-Cluster_01  
car_Asia-Cluster_02  
car_Asia-Cluster_03  
car_EMEA-Cluster_01  
car_EMEA-Cluster_02  
car_EMEA-Cluster_03  
car_India-Cluster_01  
car_India-Cluster_02  
car_India-Cluster_03 
 Thank you! 
						
					
					... View more