...
| Excerpt |
|---|
The 3-3-2 method is strategy for assigning ID values to master file records that contain longer names with no particular pattern (e.g., like Customer and Vendor Names). It builds IDs by taking the first 3 characters of the first word, the first 3 characters of the second word, and the first 2 characters of the third word. For example, "Charles Schwab Retirement" would be assigned an ID of "CHASCHRE", and "Greenway Foods" would be assigned an ID of "GREFOO". If this method results in a duplicate ID, the just add an additional digit to a segment(s)one or more of the segments. This is an easy method to implement, and it ensures that all consistency in your IDs will be close to the same length and follow a consistent pattern. |