Position function in Calculation is affecting Font choice and size in layout.
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.