1. Cleaning CSV Data
Data AnalystBackground
A dataset contains inconsistent spacing around entries, causing issues during import.
Problem
Leading and trailing whitespace in thousands of rows.
How to use
Paste the data, set Trim Type to 'From Both Sides', and Trim What to 'Whitespace'.
Outcome
All entries are perfectly aligned without extra spaces, ready for database import.
2. Removing Log Prefixes
System AdministratorBackground
Log files contain a standard 'INFO:' prefix on every line that needs to be removed for analysis.
Problem
The prefix 'INFO:' is cluttering the data.
How to use
Set Trim Type to 'From Beginning', Trim What to 'Custom Characters', and enter 'INFO:' in the custom field.
Outcome
The 'INFO:' prefix is stripped from the start of every line, leaving only the core log message.