Help Recreating Zapier Text Formatting & Filtering Workflow in ActivePieces

[ejc2013]

Hello!

I’m trying to recreate a workflow that’s working perfectly in Zapier but I’m not sure how to implement it in ActivePieces. I’d appreciate any guidance on whether this is possible and/or how to approach it.

What I’m Trying to Do:

I have a workflow in Zapier that:

1. Starts with a new asset upload in Frame io

2. Uses a “Formatter by Zapier” step to extract information from video filenames using regex pattern matching

3. Uses “Filter by Zapier” to conditionally continue the flow based on:
   • If the filename contains specific video extensions (.mp4, .mp3, .mov)
   • If the “Output Matched” value is false

The Specific Pattern:

The regex pattern I’m using is:

^(C[0-9]+)(-|\s|.?).*\.(?i)(mp4|mov|mp3|wav|m4v)

This is used to extract information from filenames like “A marketing degree in 12 seconds.mp4”

My Questions:

1. Is this type of text transformation and conditional filtering possible in ActivePieces?

2. What would be the equivalent steps/pieces to use in ActivePieces to replicate this workflow?

3. How would I implement the regex pattern extraction similar to the “Extract Pattern” transform in Zapier?

4. Are there similar filtering capabilities in ActivePieces that would allow me to check for file extensions and output match conditions?

Thank you in advance for your help!

[kishanprmr]

You can use the Text Helper piece with the Find action for the regex expression, as shown in the image.

^(C[0-9]+)(-|\s|.?).*\.(mp4|mov|mp3|wav|m4v)$.

Then you can use router piece for conditional filtering as shown in below image.

[ejc2013]

Thank you for the help! I initially got it working using javascript. Not used to using code at all but after some back and forth with Claude it helped me write some code that was able to do the job.

I think I’ll go back and try your way which I think will be easier to go back and make changes if need be, vs trying to find and debug the code. Appreciate it again!