perl语言解析html文件产生奇怪问题 - WEB程序开发 - ITPUB论坛

ITPUB论坛 » WEB程序开发 » perl语言解析html文件产生奇怪问题

liyihongcug
高级会员

精华贴数 1
个人空间 0
技术积分 9579 (123)
社区积分 1043 (902)
注册日期 2004-7-15
论坛徽章:8

使用道具

发表于 2008-1-24 11:04

perl语言解析html文件产生奇怪问题

perl已经能成功解析html xml excel
(可能vc解析能力更强但是perl在于免费高性能无价)
现解析一个新的html 发生奇特错误

INSERT py_info(rpt_id,rpt_src,enquiry_reason,report_time,name,identity_no,rpt_pn
o,rpt_comp,rpt_person,ever_nm_c,ever_iden_c,enq24m_c,loan_no_total,loan_no,loan_
amt_hist,loan_out_amt,overdue_amt,over24m_c,card_no_total,card_no,credit_limit,m
on_out_amt,date_first_card,ssi_wage,ssi_status,rri1_1,rri1_2,rri1_3,rri1_4,rri1_
5,rri1_6,rri2_1,rri2_2,rri2_3,rri2_4,rri2_5,gender,birthday,rri3_1,rri3_2,rri3_3
,rri3_4,rri3_5,marriage,education,job_title,ssi_endow_amt,ssi_reg,ssi_medic_amt,
ssi_no,ssi_house_amt,ssi_getdate,ssi_iden)VALUES('2007092011000578','0','´û¿îÉê
2007-09-20 11:29:02','½À¤','42092069X','20070911000180','Ôü´òÒøÐÐ£¨
ÖÐ¹ú£©ÓÐÏÞ¹«Ë¾ÉîÛÚ·ÖÐÐ','PL','0','0','1','0','0','0.00','0','0','0','0','0','0.0
','42098219820702069X','1982Äê07ÔÂ02ÈÕ','ºþ±±Ê¡Ð¢¸ÐÊÐ°²Â½ÊÐ','42098219820702069X
','ºþ±±Ê¡Ð¢¸ÐÊÐ°²Â½ÊÐ','¹«ÃñÉí·ÝºÅÂëÐ£ÑéÕýÈ·','1982Äê07ÔÂ02ÈÕ','ÄÐ','1','1982-07
-02','²»Ïê','²»Ïê','Ð¢¸ÐÊÐ','²»Ïê','²»Ïê',0,'²»Ïê','²»Ïê','7420.76','ÌØÇøÍâ³ÇÕò'
,'0.00','****1370','0.00','2007-09-20','42098219820702069X') at C:\srv\www\ibs\p
engyuan\cvt-py.pl line 844, <HTML> line 436.
2007-09-20 11:29:021Õý³£810.001900-01-01

其中乱码是中文。enquiry_reason,report_time 这2个字段不能同时打印(print enquiry_reason;print report_time
只能显示后者，但是2个都是有值的)
在sql语句里更是奇特，enquiry_reason（贷款申请） ,report_time（2007-01-01 49：56：56）
在语句里变成了一个值， '贷款申 2007-01-01 49：56：56 '
另外丢失了很多的字段值，将这个sql放到sql2005 查询分析器里执行总是抱错
“字段数目远远多于字段值”，经过努力查找，发现大量的数据值丢失，还有串联出错的

1不知道什么原因？
2 如何解决？

只看该作者

liyihongcug
高级会员

精华贴数 1
个人空间 0
技术积分 9579 (123)
社区积分 1043 (902)
注册日期 2004-7-15
论坛徽章:8

使用道具

发表于 2008-1-24 15:37

C:\srv\www\ibs\pengyuan>cvt-py.pl 2007092610000361.html 99999
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 112, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 114, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 118, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 120, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 123, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 125, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 138, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 142, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 158, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 170, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 179, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 191, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 200, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 211, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 230, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 239, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 241, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 246, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 248, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 253, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 255, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 259, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 262, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 266, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 271, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 274, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 278, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 281, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 285, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 295, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 299, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 333, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 374, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 381, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 389, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 396, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 403, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 405, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 432, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 434, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 448, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 589, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 593, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 778, <HTML> line 621.
Use of uninitialized value in pattern match (m//) at C:\srv\www\ibs\pengyuan\
-py.pl line 781, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 804, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 813, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 814, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 815, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 815, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 815, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 815, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 815, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 815, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 816, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 816, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 816, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 816, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 816, <HTML> line 621.
Use of uninitialized value in string eq at C:\srv\www\ibs\pengyuan\cvt-py.pl
e 63, <HTML> line 621.
Use of uninitialized value in string eq at C:\srv\www\ibs\pengyuan\cvt-py.pl
e 51, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in string eq at C:\srv\www\ibs\pengyuan\cvt-py.pl
e 70, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 817, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 818, <HTML> line 621.
Use of uninitialized value in string eq at C:\srv\www\ibs\pengyuan\cvt-py.pl
e 51, <HTML> line 621.
Use of uninitialized value in concatenation (.) or string at C:\srv\www\ibs\p
yuan\cvt-py.pl line 818, <HTML> line 621.
INSERT py_info(rpt_id,rpt_src,enquiry_reason,report_time,name,identity_no,rpt
o,rpt_comp,rpt_person,ever_nm_c,ever_iden_c,enq24m_c,loan_no_total,loan_no,lo
amt_hist,loan_out_amt,overdue_amt,over24m_c,card_no_total,card_no,credit_limi
on_out_amt,date_first_card,ssi_wage,ssi_status,rri1_1,rri1_2,rri1_3,rri1_4,rr
5,rri1_6,rri2_1,rri2_2,rri2_3,rri2_4,rri2_5,gender,birthday,rri3_1,rri3_2,rri
,rri3_4,rri3_5,marriage,education,job_title,ssi_endow_amt,ssi_reg,ssi_medic_a
ssi_no,ssi_house_amt,ssi_getdate,ssi_iden)VALUES('','0','','','','','','','',
'','','','','','','','','','','','','','','','','','','','','','','','','',''
','0000-00-00','','','','','',0,'','','0','','0','','0','0000-00-00','') at C
rv\www\ibs\pengyuan\cvt-py.pl line 822, <HTML> line 621.

C:\srv\www\ibs\pengyuan>

只看该作者