You are viewing limited content. For full access, please sign in.

Question

Question

parse filename in workflow

Workflow
Updated June 23, 2021
asked on June 22, 2021

Hi,

I have only done simple workflows.

Now I want to create a new workflow that reads in PDF in a directory path.  An email address is part of the file name. 

How do I extract the email address that is part of the file name?  For example, if the filename is

Mary-Jane Doe_mjdoe@uwo.ca_2017 Feb 27.pdf

I want to extract mjdoe@uwo.ca from the file name.  How do I extract the email address that is in between of the underscores (_)?

Thanks,
Teng

0 0

Answer

SELECTED ANSWER
replied on June 22, 2021

Hi Teng,

You can accomplish this by using a Pattern Matching activity in Workflow. If the file name is going to be in the same format that you listed above (the email address will be surrounded by two underscore characters), you can use the below Regular Expression to extract the email address.

I hope this helps!

 

Molly

2 0
replied on June 23, 2021

Good Morning!

Thank you for the solution.  It works!

Thanks,

Teng

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...