• Hi Luis,

    Thanks for the tips on posting, here is the converted csv file into an INSERT statement

    DROP TABLE mytable;

    CREATE TABLE mytable(

    FIELD1 VARCHAR(840) NOT NULL PRIMARY KEY

    );

    INSERT INTO mytable(FIELD1) VALUES ('ID,PID,SrcDB,TreeId,TargetDB,PrjId,PrjPId,DOCNAME,DOCNUM,DOCSIZE,EDITWHEN,DOCINUSE,ENTRYWHEN,EDITPROFILEWHEN,INDEXED,VERSION,DOCLOC,AUTHOR,OPERATOR,ALIAS,CHECKEDOUT,COMMENTS,COMINDEX,ARCHIVE_REQ,T_ALIAS,C_ALIAS,SUBCLASS_ALIAS,ARCHIVED,INUSEBY,INDEXABLE,ISRELATED,C1ALIAS,C2ALIAS,C3ALIAS,C4ALIAS,C5ALIAS,C6ALIAS,C7ALIAS,C8ALIAS,C9ALIAS,C10ALIAS,C11ALIAS,C12ALIAS,C13ALIAS,C14ALIAS,C15ALIAS,C16ALIAS,C29ALIAS,C30ALIAS,C31ALIAS,CDBL1,CDBL2,CDBL3,CDBL4,CBOOL1,CBOOL2,CBOOL3,CBOOL4,CDATE1,CDATE2,CDATE3,CDATE4,DECLAREWHEN,PENDING_CLOSE,PENDING_IRM,IRM,ARCHV_ID,LASTUSER,RETAIN,LOGNODEADDR,DEFAULT_SECURITY,IS_SECURED,TYPE,MSG_ID,IS_EXTERNAL,HAS_ATTACHMENT,EXTRNL_AS_NRML,FILEENTRYWHEN,FILEEDITWHEN,Status,Deleted,Msg,Error,TargetDocNum,TargetVersion,TargetPrjPId,TargetPrjId,Ctr,LastEditDate,InsertedBy,InsertedDate,OldServer,NewServer,IsMoveJob');

    INSERT INTO mytable(FIELD1) VALUES ('152,85,Active,0,Archive,NULL,NULL,Zone for G+T script,33238,15721,2015-04-06 00:00:00.000,NULL,2015-07-23 16:55:33.000,2015-04-06 00:00:00.000,NULL,1,DEFSERVER:\DATA\DOCS\ACTIVE\MILANADM\11\1\33238.1,MILANADMIN,MILANADMIN,NULL,NULL,NULL,NULL,NULL,WORDX,DOC,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,X,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,256,NULL,Document "Zone for G+T script" moved.,NULL,33238,1,NULL,12,NULL,NULL,NULL,2015-07-30 16:58:00,MILANDEMO,MILANDEMO,1');

    INSERT INTO mytable(FIELD1) VALUES ('153,86,Archive,0,Active,NULL,NULL,Zone for G+T script,33238,15721,2015-04-06 00:00:00.000,NULL,2015-07-23 16:55:33.000,2015-04-06 00:00:00.000,NULL,1,DEFSERVER:\DATA\ARCHIVE\MILANADM\11\1\33238.1,MILANADMIN,MILANADMIN,NULL,NULL,NULL,NULL,NULL,WORDX,DOC,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,X,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,256,NULL,Document "Zone for G+T script" moved.,NULL,33240,1,NULL,9646,NULL,NULL,NULL,2015-07-30 17:00:00,MILANDEMO,MILANDEMO,1');

    INSERT INTO mytable(FIELD1) VALUES ('154,87,Active,0,Archive,NULL,NULL,Zone for G+T script,33240,15721,2015-04-06 00:00:00.000,NULL,2015-07-23 16:55:33.000,2015-04-06 00:00:00.000,NULL,1,DEFSERVER:\DATA\DOCS\ACTIVE\MILANADM\11\1\33240.1,MILANADMIN,MILANADMIN,NULL,NULL,NULL,NULL,NULL,WORDX,DOC,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,X,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,256,NULL,Document "Zone for G+T script" moved.,NULL,33239,1,NULL,12,NULL,NULL,NULL,2015-07-30 17:03:00,MILANDEMO,MILANDEMO,1');

    INSERT INTO mytable(FIELD1) VALUES ('155,87,Active,0,Archive,NULL,NULL,Zone for G+T script,33240,15721,2015-04-06 00:00:00.000,NULL,2015-07-23 16:55:33.000,2015-04-06 00:00:00.000,NULL,2,DEFSERVER:\DATA\DOCS\ACTIVE\MILANADM\11\2\33240.2,MILANADMIN,MILANADMIN,NULL,NULL,NULL,NULL,NULL,WORDX,DOC,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,X,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,256,NULL,Document "Zone for G+T script" moved.,NULL,33239,2,NULL,12,NULL,NULL,NULL,2015-07-30 17:03:00,MILANDEMO,MILANDEMO,1');

    I am not sure about the rules so don't know what to post in regards to that. What makes them really the same (and you can't see it in the sample of data) but there is also a COMMENTS column which contains data like this ""oldnumber:545454", "new number:548777""

    Let me know if there is anything else needed, thanks again.