If ( Length ( Scene Strip 2) ≥ 3 Right( Scene Strip 2 20) īut I end up having 3 separate fields to get to the final results (so everything gets really messy). Then I format the scene numbers as per the format I need with the following calculation. Then I strip out the WT with this calculation. Left ( ScSlTk Position ( ScSlTk "-" 1 1 )-1) 20 becomes 020, WT13 becomes 013, Chart-1 becomes Chart since there is no number in this field).įirst I strip out the numbers/letters with this calculation. In most cases, what I am trying to do is convert these series of numbers to a 3 digit scene number. )First I create a calculation to remove the letters "WT" when these letters appear in the text. For example, I have a text field with imported numbers/letters (eg.
What I end up doing to get to my ultimate results is a do one calculation per field. I am slowly making my way through it, but I think that I might be doing some of the calculations not in the best way. I am a newbie with the calculations aspect of filemaker.
0 kommentar(er)
