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.
