How to find text in text string

[ARTHUR_BENNETT]

what formula can I run against a text field that will display all text characters up to a “,”.

Example: TEXT1, TEXT2

Result: TEXT1

[Cameron_Deleone]

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!

[ARTHUR_BENNETT]

Thank you! Worked like a charm

[ARTHUR_BENNETT]

why does it apply a leading " - - example "Aby

[Andy_Lin1]

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)

[ARTHUR_BENNETT]

Thank you Andy!

[ARTHUR_BENNETT · Accepted solution]

How do I reformat this ?
Ashbaugh, Cally
to
Cally Ashbaugh

[W_Vann_Hall]

Assuming ‘Ashbaugh, Cally’ is in a field called {Name}, use this formula:

RIGHT(Name,LEN(Name)-FIND(' ',Name))&' '&LEFT(Name,FIND(',',Name)-1)

[ARTHUR_BENNETT]

Amazing! How do I learn to write these

[W_Vann_Hall]

Start here.

Then go here.