nuc63 27 Posted March 6, 2012 Report Share Posted March 6, 2012 Having trouble deleting dupe rows in a table. Example 1,2,3,4,51,2,3,4,ea,b,c,d,e1,2,3,4,5f,g,h,i,b I would like it to be 1,2,3,4,51,2,3,4,ea,b,c,d,ef,g,h,i,b Quote Link to post Share on other sites
rumen 3 Posted March 6, 2012 Report Share Posted March 6, 2012 Thats my way. clear table(&Old table)clear table(&New table)clear list(%Temp)create table from file(".yourDataFile", &Old table)save to file(".temp", &Old table)clear table(&Old table)add list to list(%Temp, $list from file(".temp"), "Delete", "Global")save to file(".temp", %Temp)clear list(%Temp)create table from file(".temp", &New table) Have luck 1 Quote Link to post Share on other sites
nuc63 27 Posted March 7, 2012 Author Report Share Posted March 7, 2012 Thanks very much Quote Link to post Share on other sites
pusaqall 1 Posted March 7, 2012 Report Share Posted March 7, 2012 Your script looks very easy to understand. Thank you so much for such information.http://imagicon.info/cat/5-34/vbulletin-smile.gif Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.