diff options
author | levinse <levinse> | 2011-05-21 00:52:48 +0000 |
---|---|---|
committer | levinse <levinse> | 2011-05-21 00:52:48 +0000 |
commit | ed23391d8ec04f66575b352187c6812c00dce1d4 (patch) | |
tree | 148c1cf11153e8912ff0da394dddedaf8b649f6e /FS/FS/msa_Data.pm | |
parent | bb119c4cc86e906f698a205437790bd8f96bb3d0 (diff) |
DID inventory import, RT12754
Diffstat (limited to 'FS/FS/msa_Data.pm')
-rw-r--r-- | FS/FS/msa_Data.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/msa_Data.pm b/FS/FS/msa_Data.pm index be9b099..22c4263 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); |