Getting filename without extension and seperating the value based on a character

Hi All,

I want to develop a macro for getting filename without extension and seperating the value into two variables.

Requirement:

I have a folder with 3 subfolders inside.

Each subfolder has few files in it.

I will give main folder as input and it should check all subfolders/main folder for files and take that files and modify as shown in below example:

Example of one file: TEST-123_REV00.pdf

Here TEST-123 is the document name
REV00 is the revision of the document
pdf is as usual the extension.

Now my requirement is to prepare an output file with all these files in a text file.

The output is in this format..

Document Name | Revision Name.

Please help me in getting this done.

Thank you.

This may help you.
The macro creates a text file with the file and revision text.

Please Login or Register  to view this content.

Originally Posted by G e r a r d

This may help you.
The macro creates a text file with the file and revision text.

Please Login or Register  to view this content.

Hi.. Thanks for your help.. Sorry I was not clear in my first post.. For revision name I dont want REV to be added..

Example: TEST_TOOL-123_REV00.pdf

here you can see that there is an underscore between TEST and TOOL and also between 123 and REV

but TEST_TOOL-123 is document name
00 is revision.

So my output should be

TEST_TOOL-123 | 00

.. Also It should process files in subfolder as well as main folder

Thanks a lot in advance..

Changed the inst check string to _R

Also added error handling in case there is no _R in the name, the file will be skipped.

Please Login or Register  to view this content.

Thanks Gerard working as expected