#1 2019-03-21 11:08

benzo
Member
Registered: 2019-03-21
Posts: 2

insert document number from parent e-mail into attachment filenames

Hi there,

I have some e-mails exported out of a document management system.

I use a program to convert the e-mails and the attachments to PDFs.

The e-mails are named using this convention:

[Matter No. e.g. xxxx-xx] [e-mail date YYYYMMDD]_[e-mail time HHMMSS] [Description of e-mail] [Document ID - #123456_v1]

The program labels the attachments by using a specified number of characters from the beginning of the parent e-mail name, so that the attachments include the Matter No. Date and Time of the parent e-mail.  It also inserts "Attach" after this to clearly show it is an attachment.  After that, the filename of the attachment is listed.

Hence:

[Parent e-mail: first 23 characters] "Attach" [Attachment Filename]


My query therefore is whether renamer can take the Document ID from the parent e-mail filename and then insert it into the end of the filenames of the attachments?

So it would be something like:

If the files have the same text up to the first 23 or so characters (or perhaps we could introduce a delimiter symbol instead), insert the document ID into the end of the filename.

Hope this is clear, grateful for your suggestions.

Many thanks,

Benzo

Offline

#2 2019-03-21 11:58

benzo
Member
Registered: 2019-03-21
Posts: 2

Re: insert document number from parent e-mail into attachment filenames

Update - so I think I have found an easier way of doing this.  The above query is no longer necessary.

My new approach is this:

i) Use Renamer to re-arrange the e-mails before conversion to PDF
- using de-limiters I can move the Document number to earlier in the document name.

ii) E-mail conversion program then includes the document number earlier in the filename when labelling the attachments.

Offline

#3 2019-03-28 08:23

den4b
Administrator
From: den4b.com
Registered: 2006-04-06
Posts: 3,367

Re: insert document number from parent e-mail into attachment filenames

It sounds like you have already found a solution to this problem. But, for the sake of completeness, it is possible to achieve what you have initially suggested, i.e. using parts of a similarly named file.

It could be done with the Pascal Script rule, by automatically finding a file with the same first 23 characters and then extracting the relevant portion from its filename.

Let us know if you still need help.

Offline

Board footer

Powered by FluxBB