Probably easy for one of you.

[strngr12]

Hello,

I am VERY new to FMP. This is the first real task I've ever performed with it. Any help would be greatly appreciated.

I need to take two separate fields and combine them. First, I need to take a field called CLIP NAME with this format:

X59B-1 MOS

And change it to:

X59B_01

I only need to add the zero if the number in the clip name is less than 10. In other words, I need to make sure it is always a two digit number.

Then I need to take a field called Roll Camera with format:

B049

and pull just the B out of it and append it to the end of the string I need and then, finally, I need to add ".mov" to the end.

So, for example, if I had these two fields:

CLIP NAME = 144B-1

Roll Camera = A065

I need to end up with 144B_01_A.mov

Here's what I have: Substitute ( CLIP NAME ;"-";"_0")&".mov"

Can anyone help me, please? :)

[comment]

Try something like =

Let ( 

w = Substitute ( CLIP NAME ; "-" ; " " ) 

;

LeftWords ( w ; 1 ) & 

SerialIncrement ( "_00_" ; MiddleWords ( w ; 2 ; 1 ) ) & 

Left ( Roll Camera ; 1 ) & ".mov"

)

Note that there are a lot of assumptions here regarding what may change and what remains constant.

[strngr12]

Try something like =

Let ( 

w = Substitute ( CLIP NAME ; "-" ; " " ) 

;

LeftWords ( w ; 1 ) & 

SerialIncrement ( "_00_" ; MiddleWords ( w ; 2 ; 1 ) ) & 

Left ( Roll Camera ; 1 ) & ".mov"

)

Note that there are a lot of assumptions here regarding what may change and what remains constant.

Thanks! That almost works perfect. One last thing I didn't realize before. If the Roll Camera field begins with X I need to skip the X and take the next letter. For example:

Roll Camera = XC003

I need to grab the "C" and not the "X."

[comment]

Substitute out the "X", then grab the first character.