Answers.Body: <p>The %PAWS% should work.</p>
  
  <p>Another option is, which depends on the number of groups you have.</p>
  
  <p>Export all people of group PAWS to an excel with a unique identifier (external id or email address for example). Import them and place all of them in right group. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-23T16:49:53.240Z
Answers.LastActivityDate: 2015-12-23T16:49:53.240Z
Answers.UserDisplayName: Catorghans
Answers.Body: <p>As @ErikH commented correcting the data format before import may be easier if %PAWS% doesn't work.</p>
  
  <p>It looks like you're using ' - ' as your delimiter in that field, which appears to be a single value text field. </p>
  
  <p>If you set this custom field as multiple value with a comma delimiter and import you would be able to use advanced search and your group values should be available as a picklist rather than doing a string search. I believe the cell should look like aaa,bbb,ccc but you can manually put in a data point and export to find out.</p>
  
  <p>A bit more info:
  <a href="http://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Data+-+Notes" rel="nofollow">http://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Data+-+Notes</a></p>
  
  <p><a href="https://forum.civicrm.org/index.php?topic=12440.0" rel="nofollow">https://forum.civicrm.org/index.php?topic=12440.0</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-23T17:03:35.343Z
Answers.LastActivityDate: 2015-12-23T17:03:35.343Z
Answers.UserDisplayName: Eli Lisseck
Answers.Body: <p>Unfortunately, CiviCRM's import UI only allows you to add folks to one group at a time.</p>
  
  <p>If you don't have a ton of groups, another solution is to do multiple imports, one per group.  If you'd like to try that approach:</p>
  
  <ul>
  <li>First, make sure your import data has some sort of unique identifier, which hopefully you imported to the "external identifier" field.  If not, you may want to delete and reimport.  If your data doesn't have a unique identifier, you can add one in a new column in Excel/LibreOffice - instructions are <a href="https://support.office.com/en-sg/article/Automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6" rel="nofollow">here</a>.</li>
  <li>Use the "Filter" or "Sort" option in Excel to get all the members of a single group together.  Save a copy of the spreadsheet with only those folks.</li>
  <li>To speed up the import - only save the "external identifier" column!  There's no need to reimport all the data that's already there.</li>
  <li>Do this for each group.</li>
  <li>Import these saved CSV files to CiviCRM, mapping the external identifier column correctly.  CiviCRM will recognize that these contacts already exist, and will ONLY add them to the group you specify on import.</li>
  </ul>
  
  <p>Still another approach  is to use the <a href="https://civicrm.org/blogs/xavier/api_batch_tools" rel="nofollow">API CSV import</a> tool or its friend the <a href="https://civicrm.org/extensions/api-csv-import-gui" rel="nofollow">API CSV Import GUI</a> - but those are NOT tools for CiviCRM beginners!  I only mention it here for future visitors to this question.  When I use those tools, I use a lookup tool that brings the contact ID and the group ID into a CSV file.  Then I can import a single CSV file that populates all the group data.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-24T18:19:44.827Z
Answers.LastActivityDate: 2015-12-24T18:19:44.827Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.Body: <p>I would give '%PAWS%' a try, otherwise you only get the cases where PAWS is the first one?</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-23T16:38:16.000Z
Answers.Text: There might have been an easier way to this, especially if you say your old groups come in one cell? Is that not caused by your delimiter in the CSV format? If so, correcting that might be quicker/cleaner.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-23T16:53:28.380Z
Answers.Text: Thanks ErikH, I've just tried tried your suggestion of adding the quotes, but that returns no results at all.  The groups are stored in the old db in in the same cell for some reason, but they do have a dash separating them so I guess its possible to put them in seperate cells using Excel??
Answers.UserDisplayName: Matt Pitts
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-24T13:49:04.353Z
Answers.Text: So do I, but I am no Excel wizard. If you try googling on importing/exporting csv format in Excel I think you will find some useful hints.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-23T16:37:11.110Z
Answers.LastActivityDate: 2015-12-23T16:37:11.110Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I'm in the process of testing CiviCRM for managing our non-profit contacts.  I'm in the process of testing the import function.  We already have our current contacts organised into groups.  When I export out of the old database, all the groups end up in a single cell.  So I have mapped them all to a custom field on import. So far so good.  </p>
  
  <p>Now I need to search that custom field to filter the groups so I can tag them with new tags inside CiviCRM.  I hope this makes sense?  </p>
  
  <p>I have been trying to use the 'search builder' to query the custom field, using the LIKE and % but I don't seem to get all the records.  </p>
  
  <p>I know there should be 91 records with PAWS in them but I only end up with 4. See the screenshots below.</p>
  
  <p><a href="https://i.sstatic.net/Iqeao.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/Iqeao.png" alt="Search Builder"></a></p>
  
  <p><a href="https://i.sstatic.net/n5yJN.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/n5yJN.png" alt="Search Builder Results"></a></p>
  
  <p>Is there a better way to do this?</p>
  
Tags: <search><search-builder>
Title: Search Builder - find one word amongst many
ThreadText: # Search Builder - find one word amongst many
  
  (Asked by: username_0 on 2015-12-23)
  
  I'm in the process of testing CiviCRM for managing our non-profit contacts. I'm in the process of testing the import function. We already have our current contacts organised into groups. When I export out of the old database, all the groups end up in a single cell. So I have mapped them all to a custom field on import. So far so good.
  
  Now I need to search that custom field to filter the groups so I can tag them with new tags inside CiviCRM. I hope this makes sense?
  
  I have been trying to use the 'search builder' to query the custom field, using the LIKE and % but I don't seem to get all the records.
  
  I know there should be 91 records with PAWS in them but I only end up with 4. See the screenshots below.
  
  [![Search Builder](https://i.sstatic.net/Iqeao.png)](https://i.sstatic.net/Iqeao.png)
  
  [![Search Builder Results](https://i.sstatic.net/n5yJN.png)](https://i.sstatic.net/n5yJN.png)
  
  Is there a better way to do this?
  
  **Tags:** search, search-builder
  
  
  ---
  
  ## 4 answers
  
  ### Answer by username_1 on 2015-12-23. Score: 4
  
  The %PAWS% should work.
  
  Another option is, which depends on the number of groups you have.
  
  Export all people of group PAWS to an excel with a unique identifier (external id or email address for example). Import them and place all of them in right group.
  
  
  ---
  
  ### Answer by username_2 on 2015-12-23. Score: 4
  
  As @username_4 commented correcting the data format before import may be easier if %PAWS% doesn't work.
  
  It looks like you're using ' - ' as your delimiter in that field, which appears to be a single value text field.
  
  If you set this custom field as multiple value with a comma delimiter and import you would be able to use advanced search and your group values should be available as a picklist rather than doing a string search. I believe the cell should look like aaa,bbb,ccc but you can manually put in a data point and export to find out.
  
  A bit more info:
  <http://wiki.civicrm.org/confluence/display/CRMDOC/Importing+Data+-+Notes>
  
  <https://forum.civicrm.org/index.php?topic=12440.0>
  
  
  ---
  
  ### Answer by username_3 on 2015-12-24. Score: 1
  
  Unfortunately, CiviCRM's import UI only allows you to add folks to one group at a time.
  
  If you don't have a ton of groups, another solution is to do multiple imports, one per group. If you'd like to try that approach:
  
  * First, make sure your import data has some sort of unique identifier, which hopefully you imported to the "external identifier" field. If not, you may want to delete and reimport. If your data doesn't have a unique identifier, you can add one in a new column in Excel/LibreOffice - instructions are [here](https://support.office.com/en-sg/article/Automatically-number-rows-76ce49e3-d8d2-459b-bd85-ee1d3973e6e6).
  * Use the "Filter" or "Sort" option in Excel to get all the members of a single group together. Save a copy of the spreadsheet with only those folks.
  * To speed up the import - only save the "external identifier" column! There's no need to reimport all the data that's already there.
  * Do this for each group.
  * Import these saved CSV files to CiviCRM, mapping the external identifier column correctly. CiviCRM will recognize that these contacts already exist, and will ONLY add them to the group you specify on import.
  
  Still another approach is to use the [API CSV import](https://civicrm.org/blogs/xavier/api_batch_tools) tool or its friend the [API CSV Import GUI](https://civicrm.org/extensions/api-csv-import-gui) - but those are NOT tools for CiviCRM beginners! I only mention it here for future visitors to this question. When I use those tools, I use a lookup tool that brings the contact ID and the group ID into a CSV file. Then I can import a single CSV file that populates all the group data.
  
  
  ---
  
  ### Answer by username_4 on 2015-12-23. Score: 1
  
  I would give '%PAWS%' a try, otherwise you only get the cases where PAWS is the first one?
  
  > **Comments:**
  > **username_4**: There might have been an easier way to this, especially if you say your old groups come in one cell? Is that not caused by your delimiter in the CSV format? If so, correcting that might be quicker/cleaner.  
  > **username_0**: Thanks username_4, I've just tried tried your suggestion of adding the quotes, but that returns no results at all.  The groups are stored in the old db in in the same cell for some reason, but they do have a dash separating them so I guess its possible to put them in seperate cells using Excel??  
  > **username_4**: So do I, but I am no Excel wizard. If you try googling on importing/exporting csv format in Excel I think you will find some useful hints.  
  
  ---
  
  