3 CREATE OR REPLACE FUNCTION evergreen.lpad_number_substrings( TEXT, TEXT, INT ) RETURNS TEXT AS $$
4 my $string = shift; # Source string
5 my $pad = shift; # string to fill. Typically '0'. This should be a single character.
6 my $len = shift; # length of resultant padded field
9 while ($string =~ /(^|\D)(\d{1,$find})($|\D)/) {
11 $padded = $pad x ($len - length($padded)) . $padded;
12 $string = $` . $1 . $padded . $3 . $';