瀏覽單個文章
凌渡宇
Major Member
 

加入日期: Feb 2009
文章: 180
如果規則不變的話 拆成以下就比較簡單了

010501931502804817100928 1010 2343
01350193150203331714012830 1010 904308
01550193150387831713092830 1010 1377347

A1=01050193150280481710092810102343
A2=013501931502033317140128301010904308
A3=0155019315038783171309283010101377347

RIGHT(A1,LEN(A1)-FIND(1010,A1)-3)=2343
RIGHT(A2,LEN(A2)-FIND(1010,A2)-3)=904308
RIGHT(A3,LEN(A3)-FIND(1010,A3)-3)=1377347
舊 2009-08-20, 10:15 AM #6
回應時引用此文章
凌渡宇離線中