So I've been working with your formulas but running into a problem. Here is an example of a multi line text field that I am trying to pull information from into separate fields.
Moving From: Oilton, OK 74052
Moving To: Oilton, OK 74052
Distance: 0 miles
Move Date: 09/28/2016
Move Type: One Bedroom Apartment
Weight: 3,500 lbs
Lead Information Lead ID: 1543299
Lead Created: 09/18/2016 02:49 PM
Customer Name: Jennifer Smith
Phone Number: 555-55-5555
Email:
deletedemail@gmail.comIf you have any questions, please don't hesitate to email Partner Care, your partner manager, or call (666) 666-6666
This problem applies to almost all of the lines of data I'm trying to extract from this one field but an example, when I use TRIM(NotRight(Part([Basic Data], 11, ":"),9)) to get the email field, depending on the length of the persons email I may end up not getting all the email or some of the next line of data. Is there another way to only get the info after the colon regardless of the length of the text I'm trying to get?
