Extracting filename from path?

[Corys8646]

Hello everyone..

I've got a text field in a FM 8 file that contains the path to a file, each record has a different filename and the filenames are different lengths

an example of one is

C:Documents and SettingsJohn DoeDesktopFolder ImagesDCP_3034.jpg

I would like to create a new calc field that pulls just the name of the image. Is there an easy way of doing that?

Thanks

Cory

[mr_vodka]

There are many different ways to parse this out.

Try this one:

Let ( v = Substitute ( path; ""; "¶" ); GetValue ( v; ValueCount (v) ) )

You could use a calculation field or a text field with calculated value (Uncheck Do not replace existing value)