Extract certain characters from a 6 character code

[defectivo]

Hi there everyone. I'm not too sure if FileMaker can do this but why not ask. I have a variety of 6-digit course codes (ex. SNC3U8).

I would love to have a field that looks at characters 4 and 5 and just shows those results. These characters will always be 5 and 6 and show a level to identify the course with.

Ex. Course Code: SNC3U8 Course level: 3U

Thanks for your help everyone!

[Raybaudi]

Middle(course code;4;2)

[defectivo]

Thank you very much, this got me on the right track.