1. Extracting Serial Numbers
Data AnalystBackground
A list of product codes contains a prefix that needs to be removed for database entry.
Problem
The first 4 characters of every line are unnecessary prefixes.
How to use
Paste the list, set Start Index to 4, leave End Index empty, and enable 'Apply to Each Line'.
startIndex: 4, sliceMode: 'slice', perLine: trueOutcome
The tool returns a clean list of serial numbers with the prefixes removed.