title: Check multiple columns for any column greater than zero using a regex
body: <p>I need to apply a when function on multiple columns. I want to check if at least one of the columns has a value greater than 0.</p>
  <p>This is my solution:</p>
  <pre><code>df.withColumn(&quot;any value&quot;, F.when(
     (col(&quot;col1&quot;) &gt; 0) |
     (col(&quot;col2&quot;) &gt; 0) |
     (col(&quot;col3&quot;) &gt; 0) |
     ...
     (col(&quot;colX&quot;) &gt; 0)
     , &quot;any greater than 0&quot;).otherwise(None))
  </code></pre>
  <p>Is it possible to do the same task with a regex, so I don't have to write all the column names?</p>