|
Capitalize |
  
|
|
Capitalize |
|
Controlling (and fixing) the case of the data in your tables adds to the "readability" of that data. If your application doesn't force the issue the users will find a way to make a mess of things. Why some users insist on leaving CAPS LOCK turned on while others couldn't find the shift key to save their lives is one of life's great mysteries. While it's best to handle these problems in the application, you may need to do some "clean-up".
DMC gives you a great deal of control over the case of the data during Transfer, Clone and Port to SQL operations. The two main areas where this applies are Data Manipulation (Clone and Transfer) and during Port to SQL. Let's look at these two conditions separately.
For Data Manipulation:
The default method is to leave your data just the way DMC found it in your tables (also known as "CamelBack").
There are times that you want to clean up and standardize the look of the data or to create new columns of data. As part of your column mapping, you can Select the Type of Function to use:
Lower - Change everything to lower case
ex. "123 Main Street" becomes "123 main street"
UPPER - All characters will be CAPITALIZED
ex. "123 Main Street" becomes "123 MAIN STREET"
Capitalize - The first character of each word in a string will be capitalized.
ex. "123 Main Street" becomes "123 Main Street"
Capitalize 1st - Capitalize only the first character of the string.
ex. "APPROVED by Joshua" becomes "Approved by joshua"
Capitalize Adv - Starts just like Capitalize then applies the 3 exclusion lists [Capitalize (lower), Capitalize (upper) and Capitalize (pairs)]
ex. "FRED AND MARY - IPOD MP3 PLAYER" starts by becoming "Fred And Mary - Ipod Mp3 Player"
If you have "and" in Capitalize(lower), "MP3" in Capitalize (upper), and "IPOD - iPod" in Capitalize (Pairs) the result is:
"Fred and Mary - iPod MP3 Player"
DMC only applies these exclusions to whole words, so Camp3 would not change to CaMP3.
Exclusion Lists
DMC lets you maintain 3 lists to customize the way you want DMC to work with specific words and phrases that DMC encounters when working with your Data or porting your Clarion application to SQL. Let's look at these two conditions separately.
These exclusion lists only take effect when you have a function that contains Capitalize Adv. Use caution when creating your lists and test your data migration carefully before deploying your solution.
Words in your Capitalize (lower) list contains words that will be made lowercased inside a function where you select Capitalize Adv. For example, you may want words like "and", "if", "in", "on" and "else" to always be made lowercased.
Words in your Capitalize (upper) will be changed to all CAPS when you select Capitalize Adv. For example, "NE", "SE", "SW", "NW", "MP3".
You can also specify how individual words are treated by Capitalize Adv using Capitalize (pairs). Here, you can specify the precise mixed "CamelBack" case you would like to use for certain words. For example, "IPOD" becomes "iPod" and "ebay" becomes "eBay".
If you need even more control over your data you can add standard or Hand Built Conditions.