extract numbers from each side of character in a field.

Discussion created by jeff on Dec 15, 2018
Latest reply on Dec 16, 2018 by Fabrice Nordmann

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