1 2 Previous Next 16 Replies Latest reply on Feb 12, 2017 2:26 PM by keywords

    Data between variable strings

    ChrisJohnston

      I have the need to parse data that positioned between variable strings. This is the first time I need to do this in FileMaker. If it were JavaScript or C++, I would use regular expression to refer to the variable strings. I know I can use some plugins that do similar with FileMaker but I am interested in understanding how to do this in FileMaker. My text strings are like the following:

      12/11/16, 12:35:21 AM: Chris: What time will you have the backup system up and running?
      12/11/16, 12:35:47 AM: +55 21 99595-8645: Do we even have rack rails for them?
      12/11/16, 12:43:32 AM: +55 21 99595-8645: Scratch that, here are tow new boxes in the office.
      12/11/16, 12:45:39 AM: Chris: good... so what time?

      I need to extract just the text that the users are saying not the transcript entry information. How can I turn the above into this?

      What time will you have the backup system up and running?
      Do we even have rack rails for them?
      Scratch that, here are tow new boxes in the office.
      good... so what time?

      Thanks

        1 2 Previous Next