function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
b.gonzalezb.gonzalez 

Formula to copy text up to the first "." from one field and paste the text into another field.

I  need to write a formula to copy text up to the first "." from one field (Description) to another field. The formula that I have written is not working (see below). I am using a field update to copy the text into another field but the formula is not copying the text up to the first "."

 

IF( 
OR(FIND(".", Description) = LEN(Description), 
FIND(". ", Description) = 0), 
Description, 
LEFT(Description, FIND(". ", Description)) 
)

 

 

 

 

MarcPannenberg.ax1843MarcPannenberg.ax1843

Try this:

 

LEFT( Description , FIND(".", (Description & "."))-1)