title: coldfusion - remove specific text from string
body: <p>I am looking to remove "pharmacy" from an input field before I enter the text into the database. </p>
  
  <p>Example - "Ciaran pharmacy" will show as "Ciaran". </p>