Forum Discussion

ProjectsForce1's avatar
ProjectsForce1
Qrew Trainee
6 years ago

Formula Text Field

I have this data in a text field, I need to extract just the first and last name at the start of this text:

I tried:

Left(Text Box],"Email") returns first letter of first name. Any help would be appreciated. 

Billy Bob
Email: Fake@Fake.com
Mobile Phone: (419) 123-1234
HOMEOWNER INFO
Name: Billy Bob

------------------------------
ProjectsForce
------------------------------
    • ProjectsForce1's avatar
      ProjectsForce1
      Qrew Trainee
      Thank you, I had just did that and it worked. I appreciate it!!!

      ------------------------------
      ProjectsForce
      ------------------------------