Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 11, 2017 03:05 PM
what formula can I run against a text field that will display all text characters up to a “,”.
Example: TEXT1, TEXT2
Result: TEXT1
Solved! Go to Solution.
Dec 19, 2017 02:20 PM
Dec 11, 2017 05:32 PM
Hi Arthur,
This should work:
LEFT({array field}, SEARCH(",", {array field})-1)
The LEFT function will display all characters up to some index, so you just use the SEARCH function to find the index of the comma, subtracting 1 if you don’t want to include it. It should return blank for a record with no comma.
Hope that helps!
Dec 11, 2017 08:02 PM
Thank you! Worked like a charm
Dec 12, 2017 05:52 AM
why does it apply a leading " - - example "Aby
Dec 12, 2017 09:26 AM
The " appears if you have commas in a lookup field (which you do) or if you have multiple lines in a field.
To adapt the formula to remove the ", use MID instead:
MID({array field}, 1, SEARCH(",", {arrayfield})-2)
Dec 19, 2017 02:09 PM
Thank you Andy!
Dec 19, 2017 02:20 PM
How do I reformat this ?
Ashbaugh, Cally
to
Cally Ashbaugh
Dec 19, 2017 03:02 PM
Assuming ‘Ashbaugh, Cally’ is in a field called {Name}
, use this formula:
RIGHT(Name,LEN(Name)-FIND(' ',Name))&' '&LEFT(Name,FIND(',',Name)-1)
Dec 19, 2017 04:16 PM
Amazing! How do I learn to write these
Dec 20, 2017 11:52 AM
Then go here.