Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Get File Path of a Container field

ddinisco
in Calculation Engine (Define Fields)

Featured Replies

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

Let(

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

Middle ( v ; 9 ; Length ( v ) )

)

  • Author

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

thanks

David

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

Create an account or sign in to comment

https://fmforums.com/topic/77887-get-file-path-of-a-container-field/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.