I want to extract a specific piece of text from another multi line text field.

In the example above, what data are you looking to extract?  

I see three colons and no semi-colons.

I've corrected it to colons. After the colon. Let's take the text after Name: as an example of the text I want to extract (Which would be "QuickBase" in this example.

Ok. Now I get it. You want to extract the data into three separate fields. I will try to post the answer later this evening when I get a chance.

Thank you.

Hi Patrick,

So, if you ALWAYS will get that kind of values in the Multi Line Text field (named Basic Data) as

Name: QuickBase
Move Date: 9/15/2016
Phone: 000-000-0000 

And you will have 3 fields to store each value.

First formula field is Name. The code would be:    NotRight(Part([Basic Data], 2, ":"),9)

Second formula field is Move Date. The code would be:   NotRight(Part([Basic Data], 3, ":"),5)

and the third formula field is Phone. The code would be:     Right([Basic Data],":")

The first formula will look for the second colon and bring what's on its left before the first colon.

The second formula does the same but starting from the third colon.

The third formula is just looking to extract anything that is on the right side of a colon, but, since it is a multi line it will bring every thing on the right side of the last colon.

It is not a very fancy code, but I think that might work for you. Cheers.

Ricaro the Lion Tamer is mostly correct.  But I suggest wrapping his formulas in Trim(   ) to get rid of any leading or trailing spaces or other invisible characters.

That worked Thank you

You mean (NotRight(Part([Basic Data], 2, ":"),9)) as an example?

I mean like this

Trim(Right([Basic Data],":"))

QuickBaseCoach...  I think it should be TRIM(NotRight(Part([Basic Data], 2, ":"),9)) to get rid of the spaces between the colon and the value. If doing Trim(Right([Basic Data],":")) will only remove leading (before Name)and ending spaces (last phone digit..). At the end, it would look like:
TRIM(NotRight(Part([Basic Data], 2, ":"),9))
TRIM(NotRight(Part([Basic Data], 3, ":"),5))
TRIM(Right([Basic Data],":"))