Topic: Duplicated abundance qualifier
Hi everyone - wondering if someone might be able to help me with an issue please.
We've recently identified that there are two 'Present' abundance qualifiers on our system: one is simply 'Present' and the other 'Present ' (with a space)/'Present(2)'. We're not sure when or why/how this has happened, but as the two qualifiers look identical data has been entered under both without recorders realising. I'm unsure how many records this has affected overall, but it is causing real issues with reports as observations under 'Present(2)' are being missed in the output by those who don't realise that there's another abundance qualifier they should include.
Is there any way that we can identify all those records under 'Present(2)' and get them changed to 'Present'? Also is there a way to remove the the qualifier option of a second Present from our system to stop this happening again in future?
Thanks very much in advance,
Chloe