Extract number from line in file

[JulianMS]

I have a text file where every line is "number:word", so it looks something like this:

15:banana
64:cherry
1235:apple
192387:grape
238:avocado

What I want to do is extract the number associated with a given word. For example if Word was "apple", I would want to get the number 1235.
So far, I'm loading the text into a Rich Edit Object and using "Find string in string" to find where the given word starts:

Find(GetText$( "Edit Object", 0, GetNChars( "Edit Object" ) ), Word, 0)

Then I'm trying to extract the number by getting the characters that appear before the chosen word (minus the colon). I'm having trouble with this because the numbers vary in length so I can't say exactly how many characters to get. Can anyone think of a better way to do this?

[SoftWarewolf]

How about this way? tokenized.mfa
I used the String Tokenizer object.

[JulianMS]

Thanks SoftWarewolf. I eventually figured out an expression using a bunch of Right$, Left$, Len, Find etc commands but your way is much simpler!

[Popcorn]

Yeah, it is important not to over-complicate stuff
Splitting text with a delimiter is common in all programming languages, and in Fusion you can do it using the String Tokenizer or String Parser 2. String Tokenizer is often the best one and even has a 2D split feature, which would be useful in your case.
I haven't seen SoftWarewolf's example because I can't open files that uses Unicode extensions, so he might have used this same technique. You would 2D split the text with newline$ as the X delimiter, and ":" as the Y delimiter. Then you would loop through all the X items and retrieve each Y item in each.

[SoftWarewolf]

That's spot on what it does