Time Codes

[datalink]

You were all so helpful yesterday I'm hoping you can point me in the right direction again.

I've got raw data coming in that I need to parse. I've attached two examples of what it looks like:

007 3036A V C 00:44:02:12 00:44:02:12 01:00:58:21 01:00:59:05•M2 3036A 000.0 00:44:02:12

And a second example:

001 AX V C 00:00:05:16 00:00:08:17 01:00:19:20 01:00:22:21•* FROM CLIP NAME: 1549_WRIGHT PICS.JPG

I'm needing to parse out the four sets of time codes. The number of spaces between each item of data can vary, which makes it harder. The time codes are the groups of numbers separated by the ":".

Any assistance would be much appreciated.

[LaRetta]

It is the exact same theory except you need to end the pattern at 8 instead of the full field length. Why 8 and not 11 to capture the entire time? FileMaker does not recognize 00:00:00[color:red]:00. You need to change the last colon to a period or drop it altogether (FM doesn't display it anyway). You will need to pull each value independently. You could also use CF recursion but since each value must be placed in different field/record, it wouldn't really help you. So first time would be:

Let ( start = Position ( text ; ":" ; 1 ; [color:green]1 ) - 2 ; Middle ( text ; start ; 8 ) )

Second time would be same except change the occurrence of the colon (green) would be 4 etc. You can get an idea of how many times exist with: PatternCount ( text ; ":" ) / 3 and it will also tell you if the calculation will break because if this result has a fraction left, it means there is an extra colon somewhere which could break your calculation. It would be easiest to create a calculation for each time first and verify your results. Be sure to back up before you begin as well.

[datalink]

Works like a charm. Thank you so much.