Extract text between certain characters

[pcampos]

Hi there... I have a field that contains the following data:

FirstNameedro LastName:Campos Restaurant:BI Strand Location:North Month:March

I need to extract the data into different fields like this:

Field1: Pedro
Field2: Campos
Field3: BI Strand
Field4: North

Can someone explain how to extra the information I want into different fields

 

[pbaldy]

Offhand, the InStr() function will lead you to the starting position of any of the parts (and also to the end of the previous part). Combining that with the Mid() function should let you pull out any piece. I might create a function, as I suspect the logic would be easier to follow there.