2013-10-22
New Member
- Joined
- Oct 22, 2013
- Messages
- 16
I have a database table with lots of duplicate words in it and have exported the data to Excel.
Below is an extract - there are over 4,000 rows in total, where the duplicate count ranges from 8 down to 2.
The table is sorted by count_if and then word.
I'd like to find a way to mark all rows with a 'y' in the "del" column for all lines in each block of words (except the first line), so that I can filter by the y value in that column, copy the IDs and then enter in them into my database via SQL to delete the duplicates, e.g.
DELETE FROM my_table WHERE id IN (23633, 24551, 25629...);
Is that possible?
Any help would be much appreciated.
Thanks
<tbody>
</tbody>
Below is an extract - there are over 4,000 rows in total, where the duplicate count ranges from 8 down to 2.
The table is sorted by count_if and then word.
I'd like to find a way to mark all rows with a 'y' in the "del" column for all lines in each block of words (except the first line), so that I can filter by the y value in that column, copy the IDs and then enter in them into my database via SQL to delete the duplicates, e.g.
DELETE FROM my_table WHERE id IN (23633, 24551, 25629...);
Is that possible?
Any help would be much appreciated.
Thanks
id | word | cat | count_if | del |
21790 | absolute | 1 | 8 | |
23633 | absolute | 3 | 8 | y |
24551 | absolute | 3 | 8 | y |
25629 | absolute | 3 | 8 | y |
26089 | absolute | 3 | 8 | y |
27020 | absolute | 3 | 8 | y |
27506 | absolute | 3 | 8 | y |
28029 | absolute | 3 | 8 | y |
22147 | shell | 33 | 8 | |
24162 | shell | 3 | 8 | y |
25246 | shell | 3 | 8 | y |
26006 | shell | 3 | 8 | y |
27444 | shell | 3 | 8 | y |
27939 | shell | 3 | 8 | y |
28347 | shell | 3 | 8 | y |
28682 | shell | 3 | 8 | y |
11038 | string | 22 | 7 | |
22339 | string | 3 | 7 | y |
22794 | string | 3 | 7 | y |
24196 | string | 3 | 7 | y |
24406 | string | 3 | 7 | y |
24531 | string | 3 | 7 | y |
25597 | string | 3 | 7 | y |
<tbody>
</tbody>