I would like to simply remove all of the text from after the last /. The number of / would vary so I would first need to count them. Any slick way to do this?

 

/Volumes/mediaProjects4/tntt_71560_murder/forWebReview/Ep_207_Topical_V1.mov

 

remove all of the text from after the last /

Try

Left ( yourText ; Position ( yourText ; "/" ; Length ( yourText ) ; -1 ) )

Edited July 9, 201510 yr by eos

That did the trick. Thanks a lot. Here is a follow up question if you don't mind. Is there a way to examine the string for a repeat text after the last slash and remove it. It is bug with my applescript that I can not solve, so thought there may be a way to do it in FM.

 

/Volumes/mediaprojects1/job/Audio/Audio     would become    /Volumes/mediaprojects1/job/Audio

How about:

Let ( [
values = Substitute ( text ; "/" ; ¶ ) ;
n = ValueCount ( values )
] ;
Case ( 
Exact ( GetValue ( values ; n ) ; GetValue ( values ; n - 1 ) ) ; 
Left ( text ; Position ( text ; "/" ; Length ( text ) ; -1 ) - 1 ) ;
text
)
)

Or, if you prefer:

Let ( [
values = Substitute ( text ; "/" ; ¶ ) ;
n = ValueCount ( values ) ;
lastValue = GetValue ( values ; n )
] ;
Case ( 
Exact ( lastValue ; GetValue ( values ; n - 1 ) ) ; 
Left ( text ; Length ( text ) - Length ( lastValue ) - 1 )  ;
text
)
)

 

Edited July 10, 201510 yr by comment

How's this:

Let([

a = "/Volumes/mediaprojects1/job/Audio/Audio";
b = PatternCount(a, "/");
c = Position ( a ; "/" ; 1 ; b-1 );
d = Position ( a ; "/" ; 1 ; b )
];

Left(a, c) & Middle(a, d+1, 10000)

)

Edited July 10, 201510 yr by dwdata