duplicates in a file
duplicates in a file
- Subject: duplicates in a file
- From: Rick Norman <email@hidden>
- Date: Fri, 19 Jul 2002 09:09:53 -0500
Anybody got any ideas on removing duplicate entries in a tab delimited file.
I used the following script comparing "C1R1" against "C1R2" and so on. After
looking a little closer, I realize that there needs to be a little more
considered here, see the snip of the data to see what I'm referring to. This
Excel script is excruciatingly slow, I'm hoping that this can be done with
BBEdit.
Thanks
Rick Norman
set checkOne to "1"
set checkTwo to (checkOne + 1)
tell application "Microsoft Excel"
Activate
repeat
Select Range ("R" & checkOne & "C1")
set compareOne to text of Selection
Select Range ("R" & checkTwo & "C1")
set compareTwo to text of Selection
if compareOne = compareTwo then
Select Range ("R" & checkTwo)
(*set Show to text of Selection
display dialog (Show)*)
Delete Selection Shift xlUp
else
set checkOne to (checkOne + 1)
set checkTwo to (checkOne + 1)
end if
if (compareOne = "") and (compareTwo = "") then
exit repeat
end if
end repeat
end tell
Roger Jr 1234 Dalrymple Ct. Jackson MS 39211
Roger Jr 4321 Highway 22 Madison MS 39110
Clark Hughes 1111 Arbour Court Carthage MS 39501
Clark & Lucy Hughes 1111 Arbour Court Carthage MS 39501
Daryl & Kirby Neal P. O. Box 1234 Jackson MS 39207
Daryl Neal PO Box 1234 Jackson MS 39207
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.