HoldMyTwist
Clean messy text in Make with trim and lower
Remove spaces at the edges of a label and standardise its capitalisation in Make Free. Build a two-module practice workflow, inspect the result and learn what trim leaves unchanged.
In this guide
Topic
Clean messy data in Make
Fix untidy text, blank values, decimal commas, UTC times, quoted CSV columns and JSON in Make Free, with a test for the case that usually breaks.
Imported data rarely arrives clean. Work through one data problem at a time in Make Free, using small fictional examples and checking what comes out.
Start with trim and lower, because later guides reuse them. The ifempty guide replaces a blank product title with its SKU. The number and time guides read decimal commas, round up to whole packs and convert UTC to London time. The CSV and JSON guides read and write data without losing quoted commas or quotation marks.
Finish by combining CSV parsing, text cleanup and a filter in one customer-export workflow. Check its output before importing it anywhere.
Read in this order
Use a fallback for blank product names in Make
Use ifempty and trim in Make Free to replace a blank product title with its SKU. Test an empty title, a filled title and a spaces-only value.
In this guide
Convert decimal-comma text to a number in Make
Read decimal-comma text correctly in Make Free. Check 19,95 becomes 19.95, verify arithmetic, and catch a separator mistake that changes the value.
Calculate whole packs in Make with ceil
Calculate enough whole packs in Make with ceil. Follow a Free-plan example, compare round and floor, and check exact multiples and zero before using the result.
Convert UTC dates to local time in Make
Convert UTC text to London time in Make Free. Check daylight saving and avoid mixing up month and minute tokens with a worked example.
Parse CSV in Make without shifting quoted columns
Keep quoted commas, empty cells and quotation marks in the correct CSV columns. Follow a two-row Make Free example and inspect both results.
In this guide
Make Parse JSON: turn text into usable fields
Turn a small JSON object into fields you can map in Make Free. Learn why the first run matters and check the output before adding another app.
In this guide
Create JSON in Make without breaking quoted text
Build JSON from typed fields in Make Free. Keep quotation marks intact, check numeric values, and inspect the generated text before using it.
In this guide
Clean a customer CSV in Make Free before importing it
Build a Make Free CSV cleanup workflow. Trim fields, exclude blank emails and check the output before importing customer records.