Removing items from a field...

[RowN]

Hi,

I'm trying to make a calculation that will remove the last three characters from a field.

I have imported a bunch of picture files and I want to have a field that has the label of the file without the file type info.

For example:

FILENAME: A1-3.jpg (full filename)

NAME: A1-3 (the name without the extension)

Does anyone know how I can make this work in the name field? Is it a calculation?

Thanks,

Ro

[LaRetta]

Hi Ro,

It might be easier to drop everything after the period since file extensions now can be more than three characters. You might try this:

Left ( text ; Position ( text ; "." ; 1 ; PatternCount ( text ; "." ) ) - 1 )

[RowN]

Thanks LaRetta, I'm going to test this. Do I run it as a script or a calculation though?

Thank you.

Wait!!! Got it. It worked like a charm!! Thank you :laugh: