Since you probably receive files in multiple formats, here are some examples of things you can do with our Data enhancers to get organised and structured data:
- Remove dashes and commas from pincodes
- Convert all your dates to the same format
- Remove currency symbols from amounts
Listed below are the types of formatters we offer.
General Actions
- Convert to Date format
- Find and Replace
- Change Case
- Remove special characters
- Combine instances
- Change to closest match
- Keep only one entry
Numeric actions
- Integer
- Float
- Convert to Ascii
- Remove currency symbols
Database actions
- Get field from your database
- Convert to dropdown field
Regex actions
- Match Regex
- Create a new field with Regex
Create a custom action
Didn't find what you were looking for? Contact our support team for custom formatting or post-processing actions. (Alternatively create your own formatter with our Python code block)
