# Standardize

{% hint style="info" %}
This tool is currently in Beta and is still being tested. Want to learn more? Like to provide feedback? Please reach out to <support@cascade.io>
{% endhint %}

Standardize gives the user the ability to standardize columns of data into a common, specified format.

![](/files/LoQFNStoRk4NBtSeZJUF)

### Input/Output

<table data-header-hidden><thead><tr><th width="235.5">Inputs</th><th>Outputs</th></tr></thead><tbody><tr><td>Inputs</td><td>Outputs</td></tr><tr><td>Table with column(s) to be standardized</td><td>Standardized Table<br>Unstandardized Table</td></tr></tbody></table>

{% hint style="info" %}
Please Note: The 'Unstandardized Table' will contain any rows that failed to standardize within the tool.
{% endhint %}

### Options

<table data-header-hidden><thead><tr><th width="235.5">Inputs</th><th>Outputs</th></tr></thead><tbody><tr><td>Inputs</td><td>Description</td></tr><tr><td><strong>Column</strong></td><td>Column to be standardized</td></tr><tr><td><strong>Standardization Type</strong> </td><td>What data type is the column being standardized. <br>Options: <strong>[Names, Phone Numbers, Dates, URLs, Postal Codes]</strong></td></tr><tr><td><strong>Format</strong></td><td>What is the desired output format for the selected column and standardization type. Varies depending on standardization type selected.</td></tr><tr><td><strong>Failure Handling</strong></td><td>Determine how values which failed to be standardized will be handled. Options: <strong>[Fill with null value, Leave as-is, Remove entire row]</strong></td></tr></tbody></table>

### Formatting Options

<table data-header-hidden><thead><tr><th width="235.5">Inputs</th><th>Outputs</th></tr></thead><tbody><tr><td>Standardization Type</td><td>Format Options</td></tr><tr><td><strong>Names</strong></td><td>First Name, Last Name<br>Title First Middle Last Suffix<br>Last Name, First Name<br>Last Suffix, Title First Middle</td></tr><tr><td><strong>Phone Numbers</strong></td><td>US<br>International</td></tr><tr><td><strong>Dates</strong></td><td>Any Cascade supported DateTime format</td></tr><tr><td><strong>URLs</strong></td><td>http<br>https<br>www</td></tr><tr><td><strong>Postal Codes</strong></td><td>5 Digit<br>5 Plus 4<br>Either</td></tr></tbody></table>

### Example

Let's say our goal is to take our 'Name' column and convert it into a standard format:&#x20;

First Name, Last Name

![](/files/coBsLRGDpqaxLeztTqeJ)

Within the standardize tool, we would select the following items:

Standardization Type: "Names"

Column: "Name"

Formatting: "First Last"

Failure Handling: "Remove entire row"

![](/files/eWnj0dZ0dRwrT5T3Lk6i)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cascade.io/cascade/tools/cleaning/standardize.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.