Check part of filename for specific values

(0) Share

Report

Posted on by webmagic2022

Hello,

We are receiving file attachments from email messages. The filename should be structured as follows:

19934_2023_PD1.pdf (ComplexNR-Year-DocType)

By using three compose actions, the filename is checked against the following convention:

ComplexNR should contain: 5 digits
Year should contain: 4 digits
DocType should contain: 3 characters

Values are separated by a _ dash .

For Doctype we have a a mutal agreement to use only the following doctypes in the filename: PD1, PO1, PO3, DB1 . Not everyone keeps to this. We would like to check if the value for doctype is valid. When not the filename does not contain one of the doc. type values we will send a notification to the sender of the message.

How can I validate the value of the doc type?

Flow:

To check the filename:

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (3)

Report
Hi @webmagic2022,

Based on your description a Regex expression might be (just quickly tested this in regex101.com, not a regex expert over here 😁 )

^\d{5}(\s*|_)\d{4}(\s*|_)\s?(PD1|PO1|PO3|DB1)$

You could use that either in one of the existing connectors, a custom connector you create yourself or a Office script.

Below is an example with the Encodian connector

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (2)

Report

Hi @webmagic2022

Another option would be the following:

Probably @Expiscornovus solution will go faster.

Hope that helps!

Ferran

Was this reply helpful? Yes No
webmagic2022 76 on at

Like (0)

Report

Thanks @fchopo this will do the job!

Was this reply helpful? Yes No