Data formating
Learn how to clean, format, and transform data in your workflows using built-in helpers and AI suggestions for seamless automation.
- Introduction to Data Formatting in Workflows
- Use the AI copilot for formatting suggestions
- Capitalize the First Character of a Text Using the "Capitalize" Text Helper
- How to Compare Dates Using the "Compare Datetimes" Helper
- Transform Datetimes to Relative Time Using the "Transform to Relative Time" Helper
- Get the Current Datetime Using the "Get Current Date" Helper
- Add or Subtract Time from a Date Using the "Add or Subtract Datetimes" Date Helper
- Extract Portion(s) from Your Text That Match a Pattern Using the "Extract Pattern" Text Helper
- Get an Item from a List (Array) Using the "Pick from Array" Helper
- Execute custom code with "Code step" action
- Perform Math Operations Using the "Math Operation" Helper
- Truncate Text Strings Using the "Truncate" Text Helper
- Trim Whitespaces in Your Texts Using the "Trim" Text Helper
- Convert Text Values to Numbers Using the "Text to Number" Text Helper
- Find and Replace Patterns or Characters in Text Using the "Replace" Text Helper
- Split Text Using the "Split" Text Helper
- Convert Money Values to Numbers Using the "Money to Number" Text Helper
- Join All Elements of an Array to a New String Using the "Join" Text Helper
- Convert Numbers to Text Using the "Number to Text" Text Helper
- Format a Phone Number Using the "Format Phone Number" Text Helper
- Set a Fallback Value for Possibly Empty Text Using the "Fallback Value" Text Helper
- Extract a Phone Number from Text Using the "Extract Phone Number" Text Helper
- Extract a Number from Text Using the "Extract Number" Text Helper
- Adding a Lookup Table Using the "Data Mapper" Helper
- Transform and Format Date & Time Values Using the "Transform/Convert Datetimes" Helper