August 21, 2015 at 3:00 am
Hi,
I have an issue where I need to remove a duplicate row based on a value. For e.g. if there are 2 values - 1234567 and 1234567A, then the row having the value with letter A in the end should be removed.
Could someone please advise on how to achieve this ?
Thanks.
August 21, 2015 at 4:32 am
pwalter83 (8/21/2015)
Hi,I have an issue where I need to remove a duplicate row based on a value. For e.g. if there are 2 values - 1234567 and 1234567A, then the row having the value with letter A in the end should be removed.
Could someone please advise on how to achieve this ?
Thanks.
bit sparse on detail...perhaps you could provide a representative set of data?
do the duplicate rows always have 'A' at the end or are there other possibilites
is the data length consistent for all rows
ete etc
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
August 21, 2015 at 6:16 am
Another question is how to determine rows considered duplicates. Normally, this would be any row that has identical values in one column, but you're saying that 1234567 and 1234567A are duplicates even though the values are different. Is the rule that only the first 7 characters are used to identify duplicates? Or is it numbers only? Or, like J Livingston asked, is it the length?
Once you identify what flags rows as duplicates, that will determine how the delete is performed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply