date: 20131005 start time: 10:45:16 file: 02C0_1号站
date: 20131005 start time: 10:50:04 file: 02C1_2号站
date: 20131005 start time: 10:50:06 file: 02C1_2号站
date: 20131005 start time: 11:08:25 file: 04C1_3号站
date: 20131005 start time: 11:52:59 file: 02B0_4号站
date: 20131005 start time: 11:59:29 file: 03B0_5号站
date: 20131005 start time: 11:59:33 file: 03B0_5号站
date: 20131005 start time: 12:18:40 file: 04B1_6号站
求助怎么将上面红色的重复记录删除。

date: 20131005 start time: 10:50:04 file: 02C1_2号站
date: 20131005 start time: 10:50:06 file: 02C1_2号站
怎么知道删除第二条呢？

CREATE TABLE mynew(h1 C(5),h2 C(8),h3 C(5),h4 C(5),h5 C(8),h6 C(5),h7 C(10))
APPEND FROM G:\记录.txt DELIMITED WITH BLANK
CLEAR
USE mynew EXCLUSIVE
n0=VAL(SUBSTR(h7, 6,1))
SCAN  
    IF VAL(SUBSTR(h7, 6,1))<n0
        DELETE
    ELSE
        n0=VAL(SUBSTR(h7, 6,1))+1
    ENDIF
ENDSCAN
pack
BROWS

...

[ 本帖最后由 bccn0906 于 2013-11-25 17:46 编辑 ]

SET DELETED ON
CREATE CURSOR t1 (str1 varchar(80))
SELECT t1
APPEND FROM c:\记录.TXT sdf
DELETE FOR LEFT(str1,4)<>'date'
SELECT t1
str2=''
SCAN
    IF LEFT(str1,26)+ALLTRIM(SUBSTR(str1,36))==str2
        DELETE
    ELSE
        str2=LEFT(str1,26)+ALLTRIM(SUBSTR(str1,36))
    ENDIF
ENDSCAN
COPY TO c:\记录2.TXT sdf

收到的鲜花

• 悠闲小鱼 于 2013-11-26 08:30 送鲜花  3朵   附言：我很赞同

删除第二条重复的记录

CREATE CURSOR mynew (h1 C(5),h2 C(8),h3 C(5),h4 C(5),h5 C(8),h6 C(5),h7 C(10))
APPEND FROM 记录.txt DELIMITED WITH BLANK
SELECT * FROM MYNEW WHERE H5 IN (SELECT MIN(H5) H5 FROM MYNEW GROUP BY H7)