Skip to Content
Former Member
Apr 09, 2014 at 02:22 PM

removing portion of the text


Hi All,

I have the following table, Full_Name column is the original data and Modified column is from Crystal Report Formula Field. I want to take out 'in Boston', 'in New York', and 'in Los Angeles' from the Full_Name and write it under Modified (as shown in the table). It would be a simple code, I tried it many ways but it's not working. Can someone help me writing the code please. Thanks - Brian

Full_Name Modified John in Boston John Bell in New York Bell Tiger in Los Angeles Tiger Rodney in Boston Rodney Graham in Boston Graham Bill in New York Bill Marry in New York Marry Juaida in Los Angeles Juaida Felton in New York Felton Shawn in Los Angeles Shawn