1. Cleaning Bracketed Metadata
Data AnalystBackground
A list of exported user IDs contains status tags like [ACTIVE] or [PENDING] at the end of every line.
Problem
The tags are cluttering the data and need to be removed to perform a clean import into a database.
How to use
Paste the list, select 'Detect bracketed suffixes' mode, and enable 'Trim Whitespace After Removal'.
mode: bracketed, trimWhitespace: trueOutcome
All bracketed text is removed, leaving only the clean user IDs with no trailing spaces.