EvanBohanQrew Cadet8 years agoNeed to separate text into two fields. How?I have two tables that I need to relate. I figure I can do this by displaying the tables side by side (or in excel) alphabetically. Problem: One table has the name field listed as "Last Name, Firs...Show More
MCFNeilQrew CaptainEvan,You will want to use a combination of "Left" and "NotLeft" in a formula to separate out the first from the last. It will look something like this:NotLeft([Full Name], " ")&", "&Left([Full Name], " ")Let me know if that works for you.
Related ContentLookup a value with multiple conditions into a field in a separate tableAn API(?) button to copy fields from the form, to other fieldsMultiple reference proxy fields helpSeparate Multi select text for Bar graphPipeline Make Request - Return Make Request JSON Output into fields
Recent DiscussionsSave & Redirect in a Formula URL Using API_GenAddRecordFormMany to Many too Many...SolvedAre all QB notifications "No-Reply" emailsBulk create child records from selection listSolvedSelecting which fields to display from Formula URL searches