title: REGEX IF THEN ELSE Statement
body: <p>I've got a need to write a regular expression that has me scratching my head. Essentially I have a column of data that includes values such as:</p>
  
  <pre><code>ACME Corp 123
  Corp 742 ACME
  Random Text
  Broadway 1785 FB
  </code></pre>
  
  <p>What I want to do is look for the term <code>ACME</code> and <code>BROADWAY</code>. If either exists, keep that and only that. If neither exists, keep the entire string. So that column above would turn in to:</p>
  
  <pre><code>ACME
  ACME
  Random Text
  Broadway
  </code></pre>
  
  <p>Does that make sense?</p>