The backslash is a system character with a specific function, so it's not possible to query on it like a letter or number. However, the following outlines a method of using query and export to produce a file for Excel to identify organization names that utilize a backslash:

1. Create a query to identify organization records:
  • Type: Constituent
  • Format: Dynamic
  • Criteria: Constituent Information > Key Indicator equals Organization
  • Sort:  Constituent Information > Sort Key
2. Create an export of the records:
  • Type: Constituent
  • Format: CSV
  • General Tab:
    • Press Include to attach the query created above in step 1.
    • Disregard Head of Household processing and set your Include these Constituent options.
  • Output Tab:
    • Constituent Information > Sort Key
    • Constituent Information > Organization Name
    • Constituent Information > Constituent ID (or Import ID)*
    • Constituent Information > Key Indicator *
    • (*The last two fields are needed if you wish to import any revisions.)
  • Run and save your export.
3.  In Excel, open the file:
  • To the right of the Sort Key column, insert at least 5 blank columns.
  • Highlight Sort Key column and go to Data > Text to Columns to parse out the sort key column data. (If you cannot find this feature, search Excel help on Text to Columns or Parse Data.)
  • Keep the data in the column named Sort Key. Delete/Hide the other columns to bring Organization Name column beside Sort Key column.
  • Insert blank column to right of Organization Name column:
    • Create a statement to compare the sort key name with the organization name on the same row: =if(cell of sort key=cell of org name,”No Slash”,”Has Slash”)  
    •  The formula should look like this: =if(A1=C1,”No Slash”,”Has Slash”)
  • Copy and paste this formula down the column to review records:
    • If a backward slash is used in the Organization Name field, then the value will be Has Slash.
    • If there is not a backward slash present, then the value will be No Slash.