Get File Path of a Container field

[ddinisco]

I am try to simply get the path of a file that is stored in a container field as a reference only. However I would only like to receive the path, not the filename and filemac. The example below is acquired as GetAsText. I would like to see everything after filemac in the example below. Seems like there should be a Get(ContainerPath) option?

file:stories_02.mp4

filemac:/ZoeSnow/Users/david/Documents/susan_reeltoreel/stories_02.mp4

[Raybaudi]

Let(

v = GetValue ( Container ; ValueCount ( Container ) ) ;

Middle ( v ; 9 ; Length ( v ) )

)

[ddinisco]

Thanks this works great. I do not understand what it is doing however. Could you please explain?

thanks

David

[Raybaudi]

It gets the last row and deletes the first 8 chars.