FFAStrans forum

Hello all,
i need your help to define a final delivery process in my workflow, which creates a subfolder structure based on the naming convention of my source file.

Usually the naming convention of my file is:

TheEndgame_SE01_EP01.mxf

ie:

Tile_Season_episode_description

what I need, is to create a subfolder structure where i copy the file like the following:

Tile
Tile_Season
Tile_Season_episode
Tile_Season_episode_description
my file

just to better understand
i am trying using a populate metadata process before delivery process but i can not assign the correct parameters, can you please help me ?
thanks

Hey ring4life70, good to hear from you again!

No problem at all but the method that i use assumes that the characters _SExx and _EPxx do not occur in the %s_tile% part (xx means 2 numbers). If you fear it could happen that this could occur, let me know because we probably need another strategy.

Populate processor: (you have to "create" the corresponding user_variables that i use here on the left side:)
Note that the order of these instructsions does not play a role. $regext, explained:

() = use only the part inside the paranthesis. If we would not use (), e.g. we write the regex like ".+?_EP\d\d", the matched portion would include the _EP\d\d part.
.+? = this is my favourite regex, most of my regexes contain this. it means match everything up to or between. In our case as we start with .+?, it matches from "start" until what i worte after .+? (e.g. _EPxx)
_SE\d\d = match everything from start up to _SE followed by 2 numbers

Delivery processor:
Of course if you prefer you could just omit the variable definition for %s_ep_description% and instead write in the delivery processor like this:


On a sidenote, you store the title 3 times in the folder structure and 1 time in the filename, is that really neccessary? Wouldn't a folder structure like "Title\SE01\EP01" do the job?

Hi emcodem,
thanks for your time, the populate node works as desired, thanks again, however I have another issue, when I go to extract multiple audio CH from a file I have to move all the extracted tracks to the same folder as you can see in the screenshot below:
as you can see for the audio file we are using the same naming convention with the addition of the description of the CH Audio.
for all the audio files the naming convention is:

TheEndgame_SE01_EP_01_CH01.wav

Thanks

solved
i changed the variable, %s_tile_season_episode%

from:

%s_tile_season_episode% = %s_original_name%

to:

%s_tile_season_episode% = $regext("%s_original_name%","(.+?)_CH\d\d")

and used the following formula in the delivery node:

D:\LOCAL STORAGE\%s_title%\%s_title_season%\%s_title_season_episode%\AUDIO

concerning the possibility that the characters _SExx and _EPxx also appear in the %s_tile%, yes it could be possible, do we have a plan B ?

And again, is not really neccessary that we store the title 3 times in the folder structure, yes a structure like "Title\SE01\EP01" could be fine.

ring4life70 wrote: ↑Mon Dec 05, 2022 7:10 am solved
...

Well done, looks like you have no problem understanding the regexes that i used

ring4life70 wrote: ↑Mon Dec 05, 2022 7:10 am And again, is not really neccessary that we store the title 3 times in the folder structure, yes a structure like "Title\SE01\EP01" could be fine.
concerning the possibility that the characters _SExx and _EPxx also appear in the %s_tile%, yes it could be possible, do we have a plan B ?

Sure we can be a little more strict with the regex matching in order to avoid matching _EPxx within the title, we just need to further define our regex.
Why don't we use the same regex for all the parts and just move around the parantheses: This matches the "tile" part and it says that _SE\d\d_EP\d\d must be at the end (the dollar sign does this magic).

Now to get the SE part, we just move the (): You get the idea?

Of course, if there is an error in the naming, the regex will return empty "" string. If it is a human that is responsible for the correct naming of the input file, you better to an explicit check for this, e.g. after the populate processor, insert a conditional that throws an error in case...

Also and alternatively, to give you a little bit more to chew on, we could potentially check if each single part is empty and if that is the case, assign it a default value. In a populate processor, in an additional line after all the regex magic, insert a line like that:

Left side: %s_tile%,
Right side: This technique is called ternary operator, could also be called IF THEN ELSE. Just look for the definition of ternary in the internet, it should be simple to understand

Hi emcodem,

thank you very much for your solutions, I'll do some testing, and in case I come back with other questions.

thanks again