Is there a way to normalize data in Toad for Data Analysts? (4297888)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

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 STREET

PO Box 1234
P.O Box 1234
Po Box - 1234
P.O. Box #1234

Would convert to PO BOX 1234

Is 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

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title