Hi Patrick,

This code: TRIM(NotRight(Part([Basic Data], 2, ":"),9))

The 2 is to look for that character and the order of text from right to left and top to buttom. The 9 is the amount of characters to ignore before the colon, then, take all the characters before the previous colon.

Example:

Moving From: Oilton, OK 12345

Moving To: Oilton, OK 56789

Distance: 0 miles

The colon in "Moving From:" is the colon # 1.

The colon in "Moving To:" is the colon # 2.

The colon in "Distance:" is colon # 3.

So when applying the formula, you need to count the amount of characters before the colon and ending after the last user entered characters.

For example:

"Moving From" has 11 charactes (include in the count the spaces but do not add the colon in to the count.

"Moving To" has 9 characters.

"Distance" has 8 characters.

Now that you have the info, when putting the formula, just update the numbers.

TRIM(NotRight(Part([Basic Data], 2, ":"),9))

The formula will look for the second colon (the colon in Moving To:), discard the 9 characters previous to the colon (Moving To) and take value all the way before the colon #1, which will be OK 74052.

TRIM(NotRight(Part([Basic Data], 3, ":"),8))

The formula will look for the colon #3, disregard the 8 characters before that colon #3 (Distance) and give you OK 56789.

For the last value, the email address, it is a bit more tricky. You will need to create 2 new formula text fields.

The first new field will have this: TRIM(Right([Basic Data],":"))

This will extract:

deletedemail@gmail.comIf you have any questions, please don't hesitate to email Partner Care, your partner manager, or call (666) 666-6666

The second formula field could be:

Trim(NotRight(Part([Preemail], 1, "If "),0))

Assuming that after the email address, the next line will always start with "If ".

Note that I added an empty space after if in the formula just in case there is a "if" in the email address. No space should be in the email address.

Hope that helps.