I have imported the Bible from Excel. It has a field giving the reference for each record/verse. It is called "Chapter _and_verse." the text looks like "Gen.2:24". I have created two fields, one is called "chapter" and the other is "verse."
I would like a calculation for each field. One that extracts the numbers to the right of the colon into "verse",and the other to the "Chapter" field from the left the colon, excluding the "." and the lettering "Gen".
I have tried the left and right word function, but I cannot get it to give me just the numbers on each side of the colon. I am using Filemaker Advanced 17