- 论坛徽章:
- 307
|
3 楼的, 试下:- #!/usr/bin/perl
- use strict;
- use warnings;
- while (<DATA>){
- my ($last_pos, @aData) = 0;
- foreach my $num ((8, 6, 4, 8, 6)){
- my $val = substr ($_, $last_pos, $num) =~ s/\s+//r;
- push (@aData, length ($val) ? qq ('$val') : 'null');
- $last_pos += $num + 1;
- }
- print "insert into t values(", join (",", @aData), ");\n";
- }
- __DATA__
- 12345678 123456 1234 12345678 123456
- abcd abc3 7834 4556
- 34 45 dfd 444
复制代码 perl abc.pl
----------------------------------------------------------------
insert into t values('12345678','123456','1234','12345678','123456');
insert into t values('abcd','abc3',null,'7834','4556');
insert into t values('34','45','dfd','444',null);
|
|