[
    {
        "question": "Know-how",
        "answer": "Know-how - DataQualityApps",
        "url": "https://www.dataqualityapps.com/know-how.html"
    },
    {
        "question": "DataQualityApps - Search",
        "answer": "",
        "url": "https://www.dataqualityapps.com/search.html"
    },
    {
        "question": "Video tutorial (DedupeWizard)",
        "answer": "DedupeWizard: Getting Started (Video tutorial) - An introduction to the search for duplicates in address lists and databases",
        "url": "https://www.dataqualityapps.com/video-dedupewizard.html"
    },
    {
        "question": "Video tutorial (DataQualityTools)",
        "answer": "DataQualityTools: Getting Started (Video tutorial) - An introduction to the search for duplicates in address lists and databases",
        "url": "https://www.dataqualityapps.com/video-dataqualitytools.html"
    },
    {
        "question": "Processing a black list of people who do not want to receive emails",
        "answer": "Black lists are an important part of marketing. Maintaining them is not difficult. And with the help of DataQualityTools, black lists can be processed without any problems.",
        "url": "https://www.dataqualityapps.com/know-how/198-processing-a-black-list-of-people-who-do-not-want-to-receive-emails.html"
    },
    {
        "question": "Enriching addresses: supplementing data from a second source",
        "answer": "In order to enrich addresses, i.e. to transfer data from one database to another, specifically to the data record to which this information belongs, you need a way of doing this that is as automated as possible.",
        "url": "https://www.dataqualityapps.com/know-how/197-enriching-addresses-supplementing-data-from-a-second-source.html"
    },
    {
        "question": "Enriching data: Adding information from a second table",
        "answer": "In order to enrich data, i.e. to transfer information from one database to another, specifically to the data record to which this information belongs, you need a way of doing this that is as automated as possible.",
        "url": "https://www.dataqualityapps.com/know-how/196-enriching-data-adding-information-from-a-second-table.html"
    },
    {
        "question": "Merging tables: Combining two or more tables",
        "answer": "It is not uncommon to have data from different sources that needs to be processed together. The obvious solution is to combine this data, or rather the tables in which this data is stored, into a single table.",
        "url": "https://www.dataqualityapps.com/know-how/195-merging-tables-combining-two-or-more-tables.html"
    },
    {
        "question": "Determine differences between two tables",
        "answer": "Suppose you want to find out which records have been added to a table compared to an older version of the same table. Or, more generally, which records from one table are contained in a second table and which are not.",
        "url": "https://www.dataqualityapps.com/know-how/194-determine-differences-between-two-tables.html"
    },
    {
        "question": "Starting Data Cleanup via the Command Line",
        "answer": "There are scenarios where data cleanup needs to be started from a PowerShell script, a batch file, or another program. For this, BatchDeduplicator offers the option of starting projects via the command line.",
        "url": "https://www.dataqualityapps.com/know-how/193-starting-data-cleanup-via-the-command-line.html"
    },
    {
        "question": "Setting up a notification email",
        "answer": "It is, of course, convenient to be able to run a project unattended. However, if a problem arises, you naturally want to be informed about it. The easiest way to do this is probably by sending an email with a corresponding message.",
        "url": "https://www.dataqualityapps.com/know-how/192-setting-up-a-notification-email.html"
    },
    {
        "question": "Find and delete duplicates in CSV files",
        "answer": "Find and delete duplicate records in CSV files. The intelligent search for address duplicates in CSV and text files from DataQualityTools makes this possible.",
        "url": "https://www.dataqualityapps.com/know-how/191-find-and-delete-duplicates-in-csv-files.html"
    },
    {
        "question": "Find and Delete Duplicates in dbf Files",
        "answer": "Find and delete duplicates in dBase files. The intelligent search for address duplicates in dbf files from DataQualityTools makes it possible.",
        "url": "https://www.dataqualityapps.com/know-how/190-find-and-delete-duplicates-in-dbf-files.html"
    },
    {
        "question": "Remove Duplicates in OpenOffice Calc",
        "answer": "Find and delete duplicate data records in address lists and databases (OpenOffice Calc) in an error-tolerant fashion; cleanse fuzzy duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/186-remove-duplicates-in-openoffice.html"
    },
    {
        "question": "Azure SQL: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of Azure SQL and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/163-azure-sql-deduping-data-deduplication.html"
    },
    {
        "question": "Find duplicates with the Mail Merge Wizard in Word",
        "answer": "With marketing campaigns one should carry out a  search for duplicates among the addresses to be solicited.",
        "url": "https://www.dataqualityapps.com/know-how/161-find-duplicates-in-word.html"
    },
    {
        "question": "Determining the Success of Direct Marketing Campaigns",
        "answer": "To have long-term success with direct marketing campaigns, you have to know which factors are decisive for their success. To do so, you have to obtain as much information as possible about the effects of particular variations of advertising campaigns and measure their success.",
        "url": "https://www.dataqualityapps.com/know-how/160-determining-the-success-of-direct-marketing-campaigns.html"
    },
    {
        "question": "Test Advertising Campaigns with Direct Marketing",
        "answer": "Direct marketing campaigns are measurable and thus also, to a certain extent, controllable. Test advertising campaigns, where an advertising campaign is purpose",
        "url": "https://www.dataqualityapps.com/know-how/159-test-advertising-campaigns-with-direct-marketing.html"
    },
    {
        "question": "Seed Addresses with Direct Marketing",
        "answer": "Seed addresses serve to verify if, and if so, when and how the service provider produced and sent out the commissioned sales letters.  The seed addresses can also be used to provide evidence on the illegal distribution and/or use of address lists.",
        "url": "https://www.dataqualityapps.com/know-how/158-seed-addresses-for-direct-marketing.html"
    },
    {
        "question": "Preparing Database Marketing Campaigns",
        "answer": "The success of any database marketing campaign is based on the addresses used. It is easy to optimally prepare addresses for a database marketing campaign using the DeduplicationWizard.",
        "url": "https://www.dataqualityapps.com/know-how/157-preparing-database-marketing-campaigns-with-dedupewizard.html"
    },
    {
        "question": "Determining the Salutation for an Address",
        "answer": "In many countries and languages, the terms 'Mr.' or 'Mrs.' belong in the personal salutation. If this information is not included in the address list, there is always the possibility of determining the salutation using an appropriate tool based on the first name.",
        "url": "https://www.dataqualityapps.com/know-how/156-determining-the-salutation-for-an-address.html"
    },
    {
        "question": "Excel: Supplementing Leading Zeros",
        "answer": "If you are not careful in Excel and you forget to change the formatting of the column with the telephone area code from 'Standard' to 'Text', you will loose the leading zeros. With a program like the DataQualityTools, it is easy to deal with this problem.",
        "url": "https://www.dataqualityapps.com/know-how/155-excel-supplementing-leading-zeros.html"
    },
    {
        "question": "Delete duplicate addresses in Excel",
        "answer": "Address lists are generally managed with Excel. Duplicate addresses are often an issue with address lists. It is not difficult to delete them.",
        "url": "https://www.dataqualityapps.com/know-how/139-delete-duplicated-addresses-in-excel.html"
    },
    {
        "question": "Robinson Lists / Do Not Call Registry",
        "answer": "Robinson lists are lists with the names of people and companies who do not wish to receive any advertising. With their help, the costs for marketing campaigns can be reduced by eliminating advertising that would most likely fall upon deaf ears.",
        "url": "https://www.dataqualityapps.com/know-how/138-robinson-lists-do-not-call-registry.html"
    },
    {
        "question": "CSV Files and Excel",
        "answer": "CSV files can be read and processed in EXCEL. However, EXCEL has its problems with leading zeros, such as they may appear in area code or postal code data fields.",
        "url": "https://www.dataqualityapps.com/know-how/137-csv-files-and-excel.html"
    },
    {
        "question": "Remove Duplicates in LibreOffice Calc",
        "answer": "Find and delete duplicate data records in address lists and databases (LibreOffice Calc) in an error-tolerant fashion; cleanse fuzzy duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/134-remove-duplicates-in-libreoffice.html"
    },
    {
        "question": "Excel: Inserting Column Headings",
        "answer": "Add column headers for data managed with Excel in order to be able to process these better with other programs.",
        "url": "https://www.dataqualityapps.com/know-how/129-excel-inserting-column-headings.html"
    },
    {
        "question": "Duplicates with Small Differences",
        "answer": "Finding duplicates with small differences, for example, typos, transposed words, omitted letters and added letters.",
        "url": "https://www.dataqualityapps.com/know-how/128-duplicates-with-small-differences.html"
    },
    {
        "question": "MariaDB: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of MariaDB and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/127-mariadb-deduping-data.html"
    },
    {
        "question": "IBM DB2: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of IBM DB2 and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/124-ibm-db2-deduping-data.html"
    },
    {
        "question": "Find Duplicates between two Tables in Excel",
        "answer": "Compare two address lists or databases (Excel) against one another; delete or mark overlaps and enrich the data with the aid of the result.",
        "url": "https://www.dataqualityapps.com/know-how/123-find-duplicates-between-two-tables-in-excel.html"
    },
    {
        "question": "Delete duplicate addresses in Access",
        "answer": "Address lists are generally managed with Access. Duplicate addresses are often an issue with address lists. It is not difficult to delete them.",
        "url": "https://www.dataqualityapps.com/know-how/122-remove-duplicates-in-access.html"
    },
    {
        "question": "PostgreSQL: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of PostgreSQL and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/121-postgresql-deduping-data.html"
    },
    {
        "question": "Oracle: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of Oracle and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/120-oracle-deduping-data.html"
    },
    {
        "question": "MySQL: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of MySQL and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/119-mysql-deduping-data.html"
    },
    {
        "question": "SQL Server: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of SQL Server and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/118-sql-server-deduping-data.html"
    },
    {
        "question": "Access: Deduping Data (deduplication)",
        "answer": "Find and delete duplicate data records with the help of Access and the SQL query language; cleanse duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/117-access-deduping-data.html"
    },
    {
        "question": "Fuzzy Matching with SQL",
        "answer": "Find and delete duplicate data records with the help of the SOUNDEX command and the SQL query language; cleanse fuzzy duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/116-fuzzy-matching-with-sql.html"
    },
    {
        "question": "Scheduled Duplicate Detection with BatchDeduplicator",
        "answer": "Regularly cleanse duplicates from databases and data sets according to a fixed schedule in order to improve the quality of the data over the long term.",
        "url": "https://www.dataqualityapps.com/know-how/115-scheduled-duplicate-detection-with-batchdeduplicator.html"
    },
    {
        "question": "Find Duplicates between two Tables in Access",
        "answer": "Compare two address lists or databases (Access) against one another; delete or mark overlaps and enrich the data with the aid of the result.",
        "url": "https://www.dataqualityapps.com/know-how/114-find-duplicates-between-two-tables-in-access.html"
    },
    {
        "question": "Remove Duplicates in Excel",
        "answer": "Find and delete duplicate data records in address lists and databases (Excel) in an error-tolerant fashion; cleanse fuzzy duplicates from databases.",
        "url": "https://www.dataqualityapps.com/know-how/113-remove-duplicates-in-excel.html"
    },
    {
        "question": "Duplicate Addresses",
        "answer": "Duplicate entries in address lists and databases are unavoidable. But what do duplicates look like? And what can be done about them?",
        "url": "https://www.dataqualityapps.com/know-how/112-duplicate-addresses.html"
    },
    {
        "question": "Removing Duplicates in Excel / Deduplication in EXCEL",
        "answer": "Easy-to-use software to aid in the search for duplicates (dupes) in Excel (telephone, email, postal address). Free trial available.",
        "url": "https://www.dataqualityapps.com/deduplication.html"
    },
    {
        "question": "Deduplication in One File / Table",
        "answer": "Deduplication within a file/table: Here, the program looks for duplicate addresses or records within a single file/table.",
        "url": "https://www.dataqualityapps.com/deduplication-in-one-file.html"
    },
    {
        "question": "Deduplication between Two Files / Tables",
        "answer": "Deduplication between two files/tables: Here, one file/table is compared with another, e.g. to take addresses from a black list in consideration.",
        "url": "https://www.dataqualityapps.com/deduplication-between-two-files.html"
    },
    {
        "question": "Deduping EXCEL, ACCESS, SQL-Server, MySQL, MariaDB, ORACLE",
        "answer": "A program for regular search for duplicates (dupes /deduplication) performed in address tables on a fixed schedule. Free trial available.",
        "url": "https://www.dataqualityapps.com/deduping.html"
    },
    {
        "question": "Deduping Functions",
        "answer": "Fast, largely automated and user-friendly deduplication functions for address databases to find duplicates / dupes.",
        "url": "https://www.dataqualityapps.com/deduping-functions-bd.html"
    },
    {
        "question": "Project Administration",
        "answer": "With the project administration, new projects can be created and existing projects can be deleted, modified or started manually.",
        "url": "https://www.dataqualityapps.com/project-administration-bd.html"
    },
    {
        "question": "Plan the date and time for carrying out matching projects",
        "answer": "The possibility of planning projects. For example, the program could be instructed to execute a certain project every Monday at 8 pm.",
        "url": "https://www.dataqualityapps.com/task-planning.html"
    },
    {
        "question": "Command line parameters for invoking matching projects",
        "answer": "The possibility of executing one or several projects by starting the program with command line parameters.",
        "url": "https://www.dataqualityapps.com/command-line-parameters.html"
    },
    {
        "question": "Execution Log",
        "answer": "The results of a project are documented in detail. If records are modified or deleted, a backup of these records is also created in doing so.",
        "url": "https://www.dataqualityapps.com/execution-log.html"
    },
    {
        "question": "Notification Email",
        "answer": "Email about the results of a project, informing you of whether there were any problems in the processing of the project or not.",
        "url": "https://www.dataqualityapps.com/notification-email.html"
    },
    {
        "question": "Dedupe Excel, Access, SQL-Server, MariaDB, MySQL and Oracle",
        "answer": "Powerful software to aid in the search for duplicates (dupes) in databases and address lists. Free trial available.",
        "url": "https://www.dataqualityapps.com/dedupe.html"
    },
    {
        "question": "Dedupe Functions",
        "answer": "Fast, largely automated and user-friendly deduplication functions for address databases to find duplicates / dupes.",
        "url": "https://www.dataqualityapps.com/dedupe-functions.html"
    },
    {
        "question": "Processing an Email Blacklist",
        "answer": "his function can be used to delete those email addresses from a list of email addresses that do not wish to receive emails or that should not be contacted for any other reason. This requires a second list, the blacklist.",
        "url": "https://www.dataqualityapps.com/processing-an-email-blacklist.html"
    },
    {
        "question": "Processing of the Results (DataQualityTools)",
        "answer": "Functions to further process the results of the match functions (DataQualityTools)",
        "url": "https://www.dataqualityapps.com/processing-of-the-results.html"
    },
    {
        "question": "Project Management",
        "answer": "The project management offers the option to create, delete and select projects for processing.",
        "url": "https://www.dataqualityapps.com/project-management.html"
    },
    {
        "question": "Project History",
        "answer": "A project history, which provides information about what was done when with a given project.",
        "url": "https://www.dataqualityapps.com/project-history.html"
    },
    {
        "question": "Select data",
        "answer": "You can use this function to select data from a table.",
        "url": "https://www.dataqualityapps.com/select-data.html"
    },
    {
        "question": "Select data (2 Tables)",
        "answer": "You can use this function to select data from two linked tables.",
        "url": "https://www.dataqualityapps.com/select-data-2-tables.html"
    },
    {
        "question": "Select company addresses",
        "answer": "You can use this function to select addresses that can be identified by their legal form as addresses of companies.",
        "url": "https://www.dataqualityapps.com/select-company-addresses.html"
    },
    {
        "question": "Delete selected records in a table",
        "answer": "With this function, records can be deleted based on key terms. It is also possible to delete a fixed number of records.",
        "url": "https://www.dataqualityapps.com/select-addresses.html"
    },
    {
        "question": "Error-tolerant Search for Data",
        "answer": "This function can be used to search for data records that contain the searched term or at least one term that is similar to the searched term.",
        "url": "https://www.dataqualityapps.com/error-tolerant-search-for-data.html"
    },
    {
        "question": "Enrich data (2 Tables)",
        "answer": "The selection result is then used to transfer information from one table to the second table linked to it.",
        "url": "https://www.dataqualityapps.com/enrich-data-2-tables.html"
    },
    {
        "question": "Merging Tables",
        "answer": "You can use this function to combine two or more tables into a single table.",
        "url": "https://www.dataqualityapps.com/merging-tables-dqt.html"
    },
    {
        "question": "Split table",
        "answer": "This function can be used to split the contents of a table into several smaller tables.",
        "url": "https://www.dataqualityapps.com/split-table.html"
    },
    {
        "question": "Verify data field",
        "answer": "This function can be used to identify problems with the contents of individual data fields using simple criteria.",
        "url": "https://www.dataqualityapps.com/verify-data-field.html"
    },
    {
        "question": "Determine incorrect and/or incomplete addresses",
        "answer": "By using the faulty address list, incomplete and therefore erroneous addresses can be identified based on simple criteria.",
        "url": "https://www.dataqualityapps.com/faulty-addresses-list.html"
    },
    {
        "question": "Verify phone number",
        "answer": "You can use this function to check the formal correctness of a phone number.",
        "url": "https://www.dataqualityapps.com/verify-phone-number.html"
    },
    {
        "question": "Verify email address",
        "answer": "You can use this function to check the formal correctness of an email address.",
        "url": "https://www.dataqualityapps.com/verify-email-address.html"
    },
    {
        "question": "Verify URL",
        "answer": "You can use this function to check the formal correctness of an internet address (URL).",
        "url": "https://www.dataqualityapps.com/verify-url.html"
    },
    {
        "question": "Verify IBAN",
        "answer": "With this function, IBANs stored in a database can be checked for formal correctness.",
        "url": "https://www.dataqualityapps.com/verify-iban.html"
    },
    {
        "question": "Verify EAN",
        "answer": "With this function, EANs (= European Article Number) stored in a database can be checked for formal correctness.",
        "url": "https://www.dataqualityapps.com/verify-ean.html"
    },
    {
        "question": "Correct the postal code format",
        "answer": "This function corrects the format of postal codes by supplementing missing spaces, hyphens or leading zeros.",
        "url": "https://www.dataqualityapps.com/correct-the-postal-code-format.html"
    },
    {
        "question": "Formating phone numbers",
        "answer": "This function can be used to standardize the format of phone numbers.",
        "url": "https://www.dataqualityapps.com/formating-phone-numbers.html"
    },
    {
        "question": "Formating Addresses",
        "answer": "This function will permit you to standardize the space characters, to remove the control characters or to remove all characters except numbers.",
        "url": "https://www.dataqualityapps.com/formating-addresses.html"
    },
    {
        "question": "Formating Data Fields",
        "answer": "This function offers various options in order to visually improve data.",
        "url": "https://www.dataqualityapps.com/formatting-data-fields.html"
    },
    {
        "question": "Verify gender / personal salutation by means of the first name",
        "answer": "This function can be used to check the personal salutation based on the first name from the address.",
        "url": "https://www.dataqualityapps.com/check-salutation.html"
    },
    {
        "question": "Correct first name/last name mapping",
        "answer": "This function can be used to correct the mapping of the first name and last name to the corresponding data fields. So if the first name is in the data field for the last name and vice versa, then this can be corrected using this function.",
        "url": "https://www.dataqualityapps.com/correct-first-name-last-name-mapping.html"
    },
    {
        "question": "Determine individual salutations for addresses",
        "answer": "With the help of this function, the personal salutation for a letter can be created using the salutation title from the address.",
        "url": "https://www.dataqualityapps.com/determining-the-salutation.html"
    },
    {
        "question": "Determine gender / personal salutation from the first name",
        "answer": "This function can be used to determine the personal salutation based on the first name from the address.",
        "url": "https://www.dataqualityapps.com/determining-the-sex.html"
    },
    {
        "question": "Determine the industry from the name of the company",
        "answer": "With this function, addresses can be tagged with a sector code based on key terms, and thus more targeted mailings can be sent.",
        "url": "https://www.dataqualityapps.com/determining-sectors.html"
    },
    {
        "question": "Determine Country Name",
        "answer": "This function can be used to add the country name to addresses using the country code.",
        "url": "https://www.dataqualityapps.com/determine-country-name.html"
    },
    {
        "question": "Complete a data field with individual characters or terms",
        "answer": "With this function, a data field can be supplemented with one or more characters, taking account of certain specifications.",
        "url": "https://www.dataqualityapps.com/supplementing-data-fields.html"
    },
    {
        "question": "Fill a column in a table with consecutive numbers",
        "answer": "With this function, a data field can be filled with a constant or a sequential number.",
        "url": "https://www.dataqualityapps.com/fill-column.html"
    },
    {
        "question": "Create hash value",
        "answer": "With this function, the corresponding hash value (MD5 / SHA256 / SHA384) can be generated for a value. With the hash values, two data sets can be compared against each other, without the need to know the corresponding values.",
        "url": "https://www.dataqualityapps.com/create-hash-value.html"
    },
    {
        "question": "Replace individual characters in a data field",
        "answer": "With this function, characters in data fields can be replaced by other characters.",
        "url": "https://www.dataqualityapps.com/replacing-characters.html"
    },
    {
        "question": "Replace individual characters in a data field",
        "answer": "This function can be used to replace HTML characters in data fields, for example, to replace \" \" with a space character.",
        "url": "https://www.dataqualityapps.com/replacing-html-characters.html"
    },
    {
        "question": "Deleting unwanted characters",
        "answer": "This function can be used to remove unwanted characters such as symbols, emojis or control characters from a text.",
        "url": "https://www.dataqualityapps.com/deleting-unwanted-characters.html"
    },
    {
        "question": "Replace terms and words in a data field",
        "answer": "With this function, terms / words in the data fields can be replaced by other terms / words.",
        "url": "https://www.dataqualityapps.com/replacing-words.html"
    },
    {
        "question": "Create address lists with a consistent format",
        "answer": "With this function, addresses can be put into a consistent format and can thus be merged with other address lists and are easier to process.",
        "url": "https://www.dataqualityapps.com/standard-address-file.html"
    },
    {
        "question": "Deleting records",
        "answer": "With this function, a table can be pruned to a certain amount of records, in that the “dispensable” addresses at the beginning or end of the table are deleted. This way, e.g., promotional mailings can be sent to a predetermined number of addresses.",
        "url": "https://www.dataqualityapps.com/deleting-records.html"
    },
    {
        "question": "CSV-to-Excel-Converter",
        "answer": "This function can take CSV- or text-files and transform them into Excel files.",
        "url": "https://www.dataqualityapps.com/csv-to-excel-converter-dqt.html"
    },
    {
        "question": "Split one data field into two data fields",
        "answer": "With this function, the contents of a data field can be split into two data fields.",
        "url": "https://www.dataqualityapps.com/splitting-data-fields.html"
    },
    {
        "question": "Merge two data fields into a single one",
        "answer": "With this function, the contents of two data fields can be merged into one single data field.",
        "url": "https://www.dataqualityapps.com/merging-data-fields.html"
    },
    {
        "question": "Decompose a telephone number - country code, area code, phone no",
        "answer": "Splitting Telephone Numbers - international area code, area code and the telephone / fax number",
        "url": "https://www.dataqualityapps.com/splitting-telephone-numbers.html"
    },
    {
        "question": "Decompose an email address - domain, subdomain, top-level domain",
        "answer": "This function allows you to split email addresses into their component parts.",
        "url": "https://www.dataqualityapps.com/splitting-email-addresses.html"
    },
    {
        "question": "Transfer the salutation out of the name field into its own data field",
        "answer": "With this function, the salutation - Mr., Mrs., Ms., Family - can be extracted from the contact person and be stored in a separate data field.",
        "url": "https://www.dataqualityapps.com/extracting-salutations.html"
    },
    {
        "question": "Extracting Titles",
        "answer": "With this function, the title can be extracted from the contact person and stored in a separate data field.",
        "url": "https://www.dataqualityapps.com/extracting-titles.html"
    },
    {
        "question": "Decompose a name into its first and last names",
        "answer": "With this function, names can be split into their coomponent parts, i.e., the first name and the surname, and be stored in two separate data fields.",
        "url": "https://www.dataqualityapps.com/splitting-names.html"
    },
    {
        "question": "Splitting Streets",
        "answer": "This function allows one to split streets into their constituent parts and store them in two separate data fields.",
        "url": "https://www.dataqualityapps.com/splitting-streets.html"
    },
    {
        "question": "Separate postcode and city",
        "answer": "This function allows one to split a data field containing the postcode and the city into its components and store them in two separate data fields.",
        "url": "https://www.dataqualityapps.com/separate-postcode-and-city.html"
    },
    {
        "question": "Analyze table content",
        "answer": "This function can be used to analyze the content of the individual columns of a table. Among other things, it can be used to determine how many records in a given column contain a number, date or text.",
        "url": "https://www.dataqualityapps.com/analyze-table-content.html"
    },
    {
        "question": "Summary Lists",
        "answer": "Summary liste to gain an overview of existing data.",
        "url": "https://www.dataqualityapps.com/summary-lists.html"
    },
    {
        "question": "Determine difference (2 Tables)",
        "answer": "This function can be used to determine which data records from one table do not appear in a second table.",
        "url": "https://www.dataqualityapps.com/determine-difference-2-tables.html"
    },
    {
        "question": "Create ID column",
        "answer": "This function can be used to create a column with a sequential number. This can be used as an ID for the relevant data record.",
        "url": "https://www.dataqualityapps.com/create-id-column.html"
    },
    {
        "question": "Search for duplicates using an arbitrary criterion",
        "answer": "With this function, all records in the database or table can be deduped based on user-defined criteria.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/universal-matching.html"
    },
    {
        "question": "Deduplication Using the Postal Address",
        "answer": "With this function, all records in the database or table can be deduped based on their postal address.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-address.html"
    },
    {
        "question": "Deduplication Using the Telephone Number",
        "answer": "With this function, all records in the database or table can be deduped based on their telephone number.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-telephone.html"
    },
    {
        "question": "Deduplication Using the Email Address",
        "answer": "With this function, all records in the database or table can be deduped based on their email address.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-email.html"
    },
    {
        "question": "All-in-One Deduplication - email, telephone and postal address",
        "answer": "With this function, all records in the database or table can be deduped based on their postal address, telephone number and email address.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-all-in-one.html"
    },
    {
        "question": "Deduplication Using the Customer No. / Contact Person",
        "answer": "With this function, all records in the database or table can be deduped based on their customer / address number.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-customer.html"
    },
    {
        "question": "Deduplication Using the Tax Number",
        "answer": "With this function, all records in the database or table can be deduped based on their tax number.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-tax-number.html"
    },
    {
        "question": "Deduplication Using a Date",
        "answer": "With this function, all records in the database or table will be verified for duplicates using a date field.",
        "url": "https://www.dataqualityapps.com/dedupe-functions/dedupe-date.html"
    },
    {
        "question": "Sum up addresses by country",
        "answer": "With this function, the addresses stored in a database or table can be added according to the country.",
        "url": "https://www.dataqualityapps.com/summary-lists/overseas-summary-list.html"
    },
    {
        "question": "Sum up addresses by federal state",
        "answer": "With this function, the addresses stored in a database or table can be added according to the state.",
        "url": "https://www.dataqualityapps.com/summary-lists/state-summary-list.html"
    },
    {
        "question": "Sum up addresses by zip code / postal cocde",
        "answer": "With this function, the addresses stored in a database or table can be added according to the post code.",
        "url": "https://www.dataqualityapps.com/summary-lists/postal-code-summary-list.html"
    },
    {
        "question": "Sum up addresses by legal form",
        "answer": "With this function, the addresses stored in a database or table can be added according to their legal form.",
        "url": "https://www.dataqualityapps.com/summary-lists/legal-form-summary-list.html"
    },
    {
        "question": "Sum up addresses by their personal salutation / gender",
        "answer": "With this function, the addresses stored in a database or table can be added using the personal salutation.",
        "url": "https://www.dataqualityapps.com/summary-lists/salutatory-address-summary-list.html"
    },
    {
        "question": "Sum up addresses by the frequency of the words in them",
        "answer": "With this function, the words stored in a database or table can be added.",
        "url": "https://www.dataqualityapps.com/summary-lists/word-frequency-summary-list.html"
    },
    {
        "question": "Sum up addresses by their email",
        "answer": "With this function, the addresses stored in a database or table can be added using their email addresses.",
        "url": "https://www.dataqualityapps.com/summary-lists/email-summary-list.html"
    },
    {
        "question": "Sum up addresses by their telephone number",
        "answer": "With this function, the addresses stored in a database or table can be added using their area codes.",
        "url": "https://www.dataqualityapps.com/summary-lists/telephone-summary-list.html"
    },
    {
        "question": "Compare & clean up data and addresses, eliminate duplicates",
        "answer": "Software for cleaning, comparing, enhancing and selecting data from address lists and databases (Execl, Access, MySQL, MS SQL Server)",
        "url": "https://www.dataqualityapps.com/"
    },
    {
        "question": "Starting Data Cleansing via a Windows App (.net + C#)",
        "answer": "There are scenarios in which data cleansing needs to be started from a self-developed Windows app. For data cleansing, you could use BatchDeduplicator with its powerful algorithms for finding duplicates and overlaps between two tables.",
        "url": "https://www.dataqualityapps.com/know-how/199-starting-data-cleansing-via-a-windows-app-net-c.html"
    },
    {
        "question": "Processing a Telephone Blacklist",
        "answer": "This function allows you to delete telephone numbers from a list of telephone numbers that do not want to receive calls or that should not be called for any other reason. This requires a second list, the blacklist.",
        "url": "https://www.dataqualityapps.com/processing-a-telephone-blacklist.html"
    }
]