P0lar
Member
I have a list of xml command lines in excel (text fields) such as:
-f /tv/ss/ex/dub/config/agedet_one2one_run.xml -s<s> -e<e> > /tv/ss/ex/dub/config/run_agedet.log 2>&1
-f /tv/ss/in/au/config/agedet_out_run.xml -s<s> -e<e> > /tv/ss/ex/dub/config/run_agedet.log 2>&1
-f /tv/ss/ex/con/agedet_team_run.xml -s<s> -e<e> > /tv/ss/ex/dub/con/run_agedet.log 2>&1
and I need to extract the filenames which are immediately before the .xml part in all cases (so the agedet_one2one_run.xml part for example). The filepaths are always slightly different and there can be different numbers of folders in the string. The filenames always end .xml -s.
I'm looking for a text formula which will return the text string between the last "/" in the first path of the string and ".xml" (the bit hopefully in blue)
-f /tv/ss/ex/dub/config/agedet_one2one_run.xml -s<s> -e<e> > /tv/ss/ex/dub/config/run_agedet.log 2>&1
-f /tv/ss/in/au/config/agedet_out_run.xml -s<s> -e<e> > /tv/ss/ex/dub/config/run_agedet.log 2>&1
-f /tv/ss/ex/con/agedet_team_run.xml -s<s> -e<e> > /tv/ss/ex/dub/con/run_agedet.log 2>&1
and I need to extract the filenames which are immediately before the .xml part in all cases (so the agedet_one2one_run.xml part for example). The filepaths are always slightly different and there can be different numbers of folders in the string. The filenames always end .xml -s.
I'm looking for a text formula which will return the text string between the last "/" in the first path of the string and ".xml" (the bit hopefully in blue)