- Basics Unsure how to start? Learn how.
- DIY Extract Wrangles Build your own customized extract wrangles
Wrangles in the Extract category pull specific information out of a cell and, in some instances, standardize the values.
If the extract wrangle finds multiple values, it returns them as a comma separated list.
¶ Address
Addresses are an example of data that often gets lumped together into a single field. The problem is that most target systems require address parts (street, city, state etc.) to be mapped to separate fields when importing. The Address extractor can wrangle that for you!
| Option | Notes |
|---|---|
| Streets | |
| Cities | |
| Regions | The exact area extracted varies between countries, this is equivalent to states for the USA. |
| Countries |
¶ Attributes
Extract numeric attributes such as lengths or weights.
| → |
|
| Option | Notes |
|---|---|
| All | Extracts all attributes found as a JSON object |
| Angle | Angles in degrees or radians |
| Area | 2D areas such as m2 or ft2 |
| Current | Electrical current |
| Force | Forces such as newtons |
| Length | Lengths such as mm or inches |
| Power | Power such as watts or hp |
| Pressure | Pressure such as psi or bar |
| Voltage | Electrical voltages |
| Volume | 3D volumes such as m3 or ft3 |
| Weight | Weights such as grams or ounces |
¶ Brackets
Extract the contents of any brackets from the input.
| → |
|
| Option | Notes |
|---|---|
| All | Extracts the contents of any brackets. |
| Curly | {} |
| Square | [] |
| Round | () |
| Angled | <> |
¶ Codes
Extract alphanumeric codes such as part codes or order numbers.
| → |
|
¶ Properties
Extract categorical properties such as colors.
| Option | Notes |
|---|---|
| All | Extracts all properties found as a JSON object. |
| Colours | |
| Materials | |
| Shapes | |
| Standards |
¶ Output Settings
In the stock extract menu, you can change how the results are formatted if multiple results are returned with the settings button in the top right.
¶ First Element Only
Select only the first element to be returned from the extract Wrangle.
¶ Columns
Return every result from the extract in a different column.
¶ JSON
Return the results as a JSON array. e.g. [result1, result2, ...]
¶ Delimited
Return the results seperated by a delimiter, this will be the character in the text box. e.g. result1, result2, ...