AnsweredAssumed Answered

Position function in Calculation is affecting Font choice and size in layout.

Question asked by ijontichy on Aug 21, 2009
Latest reply on Aug 21, 2009 by ijontichy

Title

Position function in Calculation is affecting Font choice and size in layout.

Post

FMP10 Advanced.

 

I'm working on a database for Visual Effects work in film and this particular production has a numbering scheme that I have to parse.

 

 

 

The name of a shot is V00001A.ABC.01 (as an example.)

Information before the first . is a scene number.

Information between the two .s is a location identifier.

Information after the last . is the specific VFX shot number.

 

No problem.     Here is the formula I'm using to cull the scene number.

 

Left ( Full name ; ((Position ( Full name ; "." ; 1 ; 1 ))-1) )

 

There might be more direct ways to do this (and I'm happy to hear them), but here's the problem.

 

Any field I've created that includes the position function will no longer display in the font or size I want for my layout.  

 

I've tried the work-around of doing a second field "get as text" calculation, but to no avail.

 

 

Suggestions?

Outcomes