Download

Enhance the interpretability and efficiency of your data by generating a comprehensive phonetic token using DQ for Excel.

Our Generate feature empowers users to create a pattern representation of their data effortlessly. Tailor the generated pattern with sets of rules available in the task pane, allowing customisation such as excluding specific characters.

Untitled (1000 × 700 px) (1)

Generate Use Case Examples

Generate allows you to generate letter, number, symbol, white space and non-printing settings.

Transliteration
Pattern

The generated patterns provide a quick and intuitive way to review and identify issues within the dataset.

E.g. you have a list of counties and want to see if the data follows a consistent format.

InputOutput
HampshireCvccccvcv
H@mpshireCPccccvcv
Hampshire1Cvccccvcv1
hampshirecvccccvcv
SussexCvccvc
SurreyCvccvc
DorsetCvccvc
cumbriacvcccvv
Dev0nCvc2c
Shr0pshirECcc2cccvcV
Explanation:
  1. Vowels (v): Represented by ‘v’ in the output pattern, signifying the occurrence of a vowel in the input.
  2. Consonants (c): Represented by ‘c’ in the output pattern, denoting the presence of a consonant in the input.
  3. Punctuation (p): Represented by ‘p’ in the output pattern, alerting users to the existence of punctuation in the input.
  4. Numbers: Directly represented in the output pattern, maintaining clarity about numerical values.
  5. Capital Letters: Represented by an upper case ‘V’ or ‘C’ in the output pattern, indicating the presence of a capital letter in the input.
This use case shows how the Generate pattern representation enhances data visibility, making it easy to identify and address issues within the dataset.
Algorithms
Token

The Token feature in DQ for Excel generates phonetic representations in line with selected algorithms, including Soundex, Metaphone, and DQFonetix.

E.g. below is a comparison of token outputs for various name variations.

InputSoundexMetaphoneDQFonetix
ChristopherC623KRSTFRLAQRME
ChristoferC623KRSTFRLAQRME
CristopherC623KRSTFRLAQRME
KristopherK623KRSTFRLAQRME
KrisoferK623KHRSTFRLAQRME
KhristopherK623KHRSTFRLAQRME

This use case showcases the effectiveness of the Token feature in creating phonetic tokens, allowing for precise matching and comparison of names despite spelling or pronunciation variations. DQFonetix, with its advanced capabilities, stands out in providing the best representations for improved data accuracy.

DQFonetix contains our advanced phonetic algorithms developed over the last 25 years by DQ Global. The algorithm is property DQ Global and hence we do not share the specification of the process. However, DQFonetix has four key features:

  • Five spoken languages – English, Spanish, French, Italian and German
  • Avoids false matches
  • Overcomes character variances
  • Deals with diacritics

Business Benefits of Formatting Data:

Improved data interpretability
Quick issue identification
Easier to interpret your data
Phonetic token comparison
Customisable pattern representation
Improved data integrity

Why Generate Data in Excel?

Improved Data Interpretability

By generating comprehensive phonetic tokens using DQ for Excel, the feature enhances data interpretability and efficiency. This ensures a clearer understanding of the data, aiding in more effective decision-making.

Quick Issue Identification

The generated patterns offer a quick and intuitive way to review datasets, making it easy to identify and address issues promptly. This is especially valuable when ensuring consistent formatting, as demonstrated in the example of counties.

Advanced Phonetic Representations for Accurate Matching

The Token feature in DQ for Excel, especially DQFonetix, allows for the generation of phonetic representations. This feature ensures precise matching and comparison of names, even in cases of spelling or pronunciation variations.

Precision in Data Review

The inclusion of vowels, consonants, punctuation, numbers, and capital letters in the generated patterns provides a precise method for reviewing and understanding data. This level of detail aids in maintaining data accuracy and integrity.

Solutions

Location

Email

Person

Install DQ for Excel within minutes for complete control over your customer data.

This is how easy it is:


Warning: Undefined array key 1 in /home/customer/www/dqforexcel.dqglobal.com/public_html/wp-content/themes/Eldo/template-parts/flexible/calltoaction.php on line 63

Make an Enquiry

Product and account support