Coase Converter Module

Why can't I use the 'Prefixes' & 'Exceptions' buttons?

This feature is not available on ListCleaner Lite, however it is available on ListCleaner Pro.

What is the difference between prefixes and exceptions?

Prefixes are words that have two parts, while leaving the first part intact, capitalising the first letter of the second half.
For example if you have Mc, Mac and O' listed in your prefixes list then proper case conversion will behave as below:

john mcnamara will be John McNamara
NORMAN O'HARA will be Norman O'Hara
a.b. macwilliams will be A.B. MacWilliams

Exceptions is basically a list that will exclude from the proper case conversion certain values.
These values could be always capital values like "UN", "IBM", "UNESCO" or special values like "dB", "One2One", etc.

The values included in the exceptions list will always be converted to the form they are listed in the exceptions list.
So for example if dB and NASA are included in the exceptions list

nasa will be NASA
Nasa will be NASA
DB will be dB
db will be dB, while all other entries are converted to "proper case".

How can I build my own list of prefixes and exceptions?

This feature is not available on ListCleaner Lite, however it is available on ListCleaner Pro.

Simply click either the 'prefixes' or 'exceptions' button, and add the values that you require. These values will be stored for when you use WinPure ListCleaner again.

Can I use wildcards on the filter, so I can just change to Proper Case specific values (eg. Change to Proper Case all the values that start with '1' ?

Yes, WinPure ListCleaner Lite is equipped with very powerful and flexible filtering and wildcards.

To change all Proper Case the values that start with '1', simple place '1*' in the filter box, then click 'Change Case'.

* Matches any number of characters. It can be used as the first or last character in the character string. st* finds street, store, and staines.
? Matches any single alphabetic character. B?ll finds ball, bell, and bill
[ ] Matches any single character within the brackets. B[ae]ll finds ball and
bell but not bill
! Matches any character not in the brackets. b[!ae]ll finds bill and bull
but not bell
- Matches any one of a range of characters. You must specify the range in ascending order (A to Z, not Z to A). b[a-c]d finds bad, bbd, and bcd
# Matches any single numeric character. 1#3 finds 103, 113, 123

When I click 'Special', there are more options on the filter, what are these for?

These are all different types of filtering functions. Alpha, numeric and punctuation within values, can all be filtered by selecting the desired options.

Is it possible to change more than one field at the same time?

No, you can only convert one column at a time.

Can I sort the values into alphabetical order?

Yes, simply click the column name at the top of the list, and WinPure ListCleaner will automatically sort into ascending order. By clicking again, it will then sort into descending order. You can also sort the counts by doing the same procedure.

How do I filter each individual value on the list?

Click on the value, then click right-mouse button, this will then filter the value on Data Table.