Skip to content

Find patterns in plain text

Turn a supplier email, fixed-width report or block of tickets into records.

Open Make sense of this

Find a pattern

  1. Open Make sense of this from the Source panel. Paste the text or choose Open text file.
  2. Select Find patterns. If more than one reading fits, use Reading as to compare them.
  3. Select a line number to see the original. Show only records needing review picks out partial and unmatched records.

Teach a field

  1. Open Teach by example and choose a representative line. Highlight a value, or type it into Example value.
  2. Give it a field name and select Add field. Repeat for the other values you want, then select Test this pattern.
  3. Check another record and an exception. Save a pattern recipe if this layout comes round regularly.

Keep the awkward lines

In the supplier example, “awaiting price” stays with the product and its price is blank. Use table in converter carries all records across, including those hidden by the review filter. When review is needed, the export includes the reason and the original text for those entries.