Hello friends! I’m struggling with what I feel like should be pretty obvious but I keep hitting a wall. See below for a breakdown of the issue:
So basically, we have a bunch of digital assets with a standard filenaming convention. It goes Type_AssetName_Stage_Artist_Version, where Stage could be Rough, Clean or Color. For example:
PR_Shovel_Rough_Bob_v01
CH_Fancy_Lady_Clean_Joe_v03
BG_Ext_Dentist_Office_Color_Karen_v02
I want to make a Formatter step that takes these filenames, whatever they are, and trim off the _Stage and everything after it. So PR_Shovel_Rough_Bob_v01 would become PR_Shovel, CH_Fancy_Lady_Clean_Joe_v03 > CH_Fancy_Lady, BG_Ext_Dentist_Office_Color_Karen_v02 > BG_Ext_Dentist_Office_Color
I know how to do this using formula functions in either Google Sheets or Airtable. My formula finds either ‘_rough’, ‘_clean’ or ‘_color’ then trims it and everything after using FIND and MID. However, Zapier doesn’t seem to have the functions I need under Formatter > Numbers > Spreadsheet Style Formula (only number functions there, nothing like MID or FIND) or Formatter > Text > Split Text (great but requires a separate step for each possible Stage which gets really clunky).
I’d really like to avoid having to put the filename through Google Sheets for it to output what I need. The ultimate dream would be for Formatter > Text > Split Text to allow multiple options under Separator but that doesn’t seem to be how it works. I would also be happy if the Formatter > Numbers > Spreadsheet Style Formula had text functions. But even so, I feel like this isn’t that complicated and should be able to be achieved in Zapier with one step. Any suggestions on how I could achieve this would be great! Thank you!
