You are not logged in.
- Topics: Active | Unanswered | Last 2 weeks
#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,440
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