title: Replace string if it contains certain substring in PySpark
body: <p>Need to update a PySpark dataframe if the column contains the certain substring</p>
  <p>for example:</p>
  <p>df looks like</p>
  <pre><code>id      address
  1       spring-field_garden
  2       spring-field_lane
  3       new_berry place
  </code></pre>
  <p>If the address column contains <code>spring-field_</code> just replace it with <code>spring-field</code>.</p>
  <p>Expected result:</p>
  <pre><code>id      address
  1       spring-field
  2       spring-field
  3       new_berry place
  </code></pre>
  <p>Tried:</p>
  <pre><code>df = df.withColumn('address',F.regexp_replace(F.col('address'), 'spring-field_*', 'spring-field'))
  </code></pre>
  <p>Seems not working.</p>