Remove File Extensions From a List of Files

[justinfoote]

I have a multiple very long lists containing file names. I'd like to
strip the extensions off and compare names together.
Does anyone know of a way to make
xxxxx.prt
turn into
xxxxx

Thanks

 

[Beege]

(e-mail address removed)> wrote in message

I have a multiple very long lists containing file names. I'd like to
strip the extensions off and compare names together.
Does anyone know of a way to make
xxxxx.prt
turn into
xxxxx

Thanks

If you have all files with a three letter extension, you can use a
combination of LEFT() and LEN() to show the file minus the extension...

I'll check back to see if you've figured it out.

Beege

 

[justinfoote]

Worked perfectly, thanks

 

[Beege]

Glad to help,

Beege