The Standardize Wrangle can be used to replace words or patterns with their "standardized" form. You can think of this Wrangle as a smart find-and-replace feature. In addition to our Standardize Stock Wrangles, you can customize Standardize Wrangles so that they are much more unique to your use case.
Click here to learn how to use Standardize Wrangles in a recipe.
- Spaces
- Phone Number
- Fraction to Decimal
- Remove Characters
- Significant Figures
- Replace
- Round
Stock Wrangles are available out of the box and can be used in the following ways:
Standardize each fraction into its decimal equivalent.
Example
Standardize phone numbers to a consistent format by choosing from predefined format options or customizing your own.
Note: This Wrangle reformats phone numbers starting from the last digit and cuts off any excess digits outside the specified format. It performs the reformatting from right to left.
Options
| Option |
Example |
| (XXX) XXX XXXX |
(123) 456 7890 |
| (XXX)-XXX-XXXX |
(123)-456-7890 |
| XXX XXX XXXX |
123 456 7890 |
| Custom format example: XXX-XXX |
567-890 |
Standardize your data by removing specific characters.
Example
Character to Remove: !
| | |
|---|
| Before |
| I would love to tell you about Wrangle works! It's so cool. |
| Wrangle Works is the BEST! |
|
→
|
| After |
| I would love to tell you about Wrangle works It's so cool. |
| Wrangle Works is the BEST |
|
Standardize your data by removing specific words.
Example
Removing Part Numbers From Description
| | |
|---|
| Description |
Part Number |
| Sartwatch Apple 0000ADKEJN88ENK Red $600 |
0000ADKEJN88ENK |
| Voluptatem Samsung 2lb Blue 0000AHYR898RFHUI $100 |
0000AHYR898RFHUI |
| 0000HHGT7TR97H GGL Steel TV AAA $100 |
0000HHGT7TR97H |
|
→
|
| Description - Remove Words |
| Sartwatch Apple Red $600 |
| Voluptatem Samsung 2lb Blue $100 |
| 0000HHGT7TR97H GGL Steel TV AAA $100 |
|
Standardize data with our find and replace functionality; optionally utilize regular expressions for advanced matching.
Click here to learn how to use Replace Wrangles in a recipe.
Example
| | |
|---|
| Before |
| Wrangle works is 4 years old |
| Wrangle works is 4 years old |
|
→
|
| Regex |
| Off - Find: young , Replace: old |
| On - Find: \d , Replace: # |
|
→
|
| After |
| Wrangle works is 4 years young |
| Wrangle works is # years old |
|
Round to a set number of decimal places. Number of decimal places to round to can be set by the user. The example below shows rounding to two decimal places.
Click here to learn how to use Round Wrangles in a recipe.
| | |
|---|
| Before |
| 3.14159265359 |
| 2.718281828459045 |
| 6.02214076 × 10^23 |
|
→
|
| After |
| 3.14 |
| 2.72 |
| 6.02 x 10^23 |
|
Standardize the precision of your numerical data by specifying the desired number of significant figures.
Example
Standardize text by eliminating extra spaces and converting special space characters to a single space.
Example
In the case of zero width space in a URL