java 如何处理每行数据的列数不一致问题？

Question

数据如下（逗号分割）：
13701912508,20180310,14:51,123,456,156,365,789
13951863852,20180312,8:58,123,456,156,365,789,698
15968339885,20180312,16:15,456,156,365
13757327050,20180313,13:35,365,789,698
13958037749,20180314,15:47,365
15958366077,20180315,15:36,456,156
18357378777,20180315,15:32,698
13905731841,20180317,0:16,456,2

Answer 1

你应该首先将你的数据标准化
转换成如下的格式

电话,时间,值
13701912508,20180310 14:51,123
13701912508,20180310 14:51,456
13701912508,20180310 14:51,156
13701912508,20180310 14:51,365
13701912508,20180310 14:51,789
13951863852,20180312 8:58,123
13951863852,20180312 8:58,456
13951863852,20180312 8:58,156
...
13951863852,20180312 8:58,698
15968339885,20180312 16:15,456
...
...
13905731841,20180317 0:16,456
13905731841,20180317 0:16,2

这一步，两层循环可以搞定，先按行读取数据，然后split(",")，循环将第四列到最后一列和前面的三列插入list

然后再存入数据库或者处理，就很容易了。