Discussions

Expand all | Collapse all

Formula Text Field

  • 1.  Formula Text Field

    Posted 23 days ago
    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
    ------------------------------


  • 2.  RE: Formula Text Field

    Posted 23 days ago
    Try this
    Trim(Left([Text Box],"\n"))

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------



  • 3.  RE: Formula Text Field

    Posted 23 days ago
    Thank you, I had just did that and it worked. I appreciate it!!!

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