Use this data enhancement if you have a file where records are in "ALL CAPS" and you want them changed to mixed case lettering. Mixed case lettering is also known as Upper/Lower case.
DATA ENHANCEMENT - Upper/Lower
| BEFORE | ||||
|---|---|---|---|---|
| NAME | ADDRESS | CITY | STATE | ZIP |
| WILLIAM R SMITH | 3200 NW ELLSWORTH ST | LOS ANGELES | CA | 90026 |
| SALLY ROBINSON | 4512 BEECHMONT DR | ANDERSON | IN | 46012 |
| KEVIN C JOHNSON | 708 ALAMEDA DR | HUNTINGTOWN | MD | 20639 |
| ROBERT A MICHAELS | 125 CAMPGROUND LN | PILOT MOUNTAIN | NC | 27041 |
| DAVID L ALBERTS | 11105 BRITTSVILLE RD | GEORGETOWN | TN | 37336 |
| AFTER | ||||
|---|---|---|---|---|
| NAME | ADDRESS | CITY | STATE | ZIP |
| William R Smith | 3200 NW Ellsworth St | Los Angeles | CA | 90026 |
| Sally Robinson | 4512 Beechmont Dr | Anderson | IN | 46012 |
| Kevin C Johnson | 708 Alameda Dr | Huntingtown | MD | 20639 |
| Robert A Michaels | 125 Campground Ln | Pilot Mountain | NC | 27041 |
| David L Alberts | 11105 Brittsville Rd | Georgetown | TN | 37336 |
