Solution Category: Data processing
Data checking, structuring and transforming
Name
Brief Description
Adds spacing characters in front of numeric ids so that their length is the same. ie 10 & 200 could be converted to 00010 & 00200. This allows for correct alpha-numeric sorting. Instead of data being sorted as [Team 1, Team 11, Team 2, Team 3], it will be sorted as [Team 001, Team 002, Team 003, Team 011]
Replaces multiple instances of a defined character within a string with a single instance of a specified character ie “sdfdes——sdfhd—–kghgh—-hsdfh–” -> “sdfdes-sdfhd-kghgh-hsdfh-“