Return
-
Title
Is there a way to normalize data in Toad for Data Analysts? -
Description
User is looking for a way to normalize or standardize data using Toad for Data Analysts. For example, if they have a table with an Address column, it may contain data like the following:
123 Main Street
123 MAIN Street
123 MAIN ST
123 Main Ave
123 North Main Sreet
123 N. Main Street.Would convert to 123 MAIN STREETPO Box 1234
P.O Box 1234
Po Box - 1234
P.O. Box #1234Would convert to PO BOX 1234Is there any functionality built into TDA to change the data so that it is in some standard string, and removes puncutations like "." and "#" and makes the data all caps? -
Resolution
STATUS:
There currently no functionality or utility to do this automatically in Toad for Data Analysts. The user may be able to accomplish this using stored procedures written for the database or table. An enhancement request has been submitted to the development team for consideration in a future release of Toad for Data Analysts.
-
Defect ID
ST76730