X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=FS%2FFS%2Fmsa_Data.pm;h=22c4263bd76f9c9654e6e495af8f9b58686adfaf;hp=be9b099987ca6f77d3240152475f852ac8dc90f7;hb=aed8ec35ccb9cdeb7ea0cb6ff2946f9d83d582f6;hpb=7091372fa4580cc041feb25263ac3c1d67c59e3f diff --git a/FS/FS/msa_Data.pm b/FS/FS/msa_Data.pm index be9b09998..22c4263bd 100644 --- a/FS/FS/msa_Data.pm +++ b/FS/FS/msa_Data.pm @@ -17,7 +17,7 @@ unless ( $count ) { my $sql = 'insert into msa (msanum, description) values '; my @sql; foreach my $row ( @content ) { - next unless $row =~ /^([0-9]{5})\s+([A-Za-z, \-]{5,80}) .{3}ropolitan Statistical Area/; + next unless $row =~ /^([0-9]{5})\s+([A-Za-z,\. \-]{5,80}) .{3}ropolitan Statistical Area/; push @sql, "( $1, '$2')"; } $sql .= join(',',@sql);