Comments
-
Nice solution @ST_-Superman-_. If you want to standardise the number of characters, but your string length (@official_id in my example) is unknown, you can take the following extra steps: 1. STRING OPERATION to add large number of leading spaces to left hand side. 2. REPLACE TEXT (RegEx) to change the spaces to 0s. 3.…