Answers.Body: <p>Stepping outside civi you could do this in Drupal Views via a Views Block using a Global "Combine Fields Filter", and set the resulting records with a link back to their civi contact. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-18T20:47:41.880Z
Answers.LastActivityDate: 2015-05-18T20:47:41.880Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>This isn't a feature that exists out of the box - but addresses support custom fields, so if you're comfortable writing an extension, you could do this.  Create an extension with a <code>hook_civicrm_pre</code> that looks something like this:</p>
  
  <pre><code>function sharedaddresschanges_civicrm_pre( $op, $objectName, $id, &amp;$params ) {
    if (($op == 'create' || $op == 'edit') &amp;&amp; $objectName == 'Address') {
      $result = civicrm_api3('CustomValue', 'create', array(
        'entity_id' =&gt; $id,
        'custom_xx' =&gt; "street_address supplemental_address_1 city etc etc."
      );
    }
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-18T14:24:03.057Z
Answers.LastActivityDate: 2015-05-18T14:24:03.057Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>You could use the Full Text Search feature which offers <em>some</em> of what you requested. It supports sql wildcards but not regex, and it does search across multiple tables and columns, although it doesn't concatenate them together first.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-05-22T01:25:14.823Z
Answers.LastActivityDate: 2015-05-22T01:25:14.823Z
Answers.UserDisplayName: Coleman
Body: <p>Kindly help us with address search builder please. We wanted to make all the fields in the address as one string and then search for the address using reg expression.</p>
  
Tags: <search>
Title: How to search all the fields in address as one string
ThreadText: # How to search all the fields in address as one string
  
  (Asked by: username_0 on 2015-05-18)
  
  Kindly help us with address search builder please. We wanted to make all the fields in the address as one string and then search for the address using reg expression.
  
  **Tags:** search
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2015-05-18. Score: 2
  
  Stepping outside civi you could do this in Drupal Views via a Views Block using a Global "Combine Fields Filter", and set the resulting records with a link back to their civi contact.
  
  
  ---
  
  ### Answer by username_2 on 2015-05-18. Score: 2
  
  This isn't a feature that exists out of the box - but addresses support custom fields, so if you're comfortable writing an extension, you could do this.  Create an extension with a hook_civicrm_pre that looks something like this:
  function sharedaddresschanges_civicrm_pre( $op, $objectName, $id, &$params ) {
    if (($op == 'create' || $op == 'edit') && $objectName == 'Address') {
      $result = civicrm_api3('CustomValue', 'create', array(
        'entity_id' => $id,
        'custom_xx' => "street_address supplemental_address_1 city etc etc."
      );
    }
  
  
  ---
  
  ### Answer by username_3 on 2015-05-22. Score: 0
  
  You could use the Full Text Search feature which offers *some* of what you requested. It supports sql wildcards but not regex, and it does search across multiple tables and columns, although it doesn't concatenate them together first.
  
  
  ---
  
  