I have managed to do a lot of work regarding point data in the wrong projection, I forgot to change CRS from user 1000005 to BNG before I saved the layer as BNG so now it thinks it is in BNG only it is in the wrong location by a few meters.
I have managed to give each point which is the same, only in the wrong location, the same unique ID number and have the list of numbers (14,000+) saved as a text file with each ID being separated by a comma.
Is there a way i can use this list of ID's to select the relevant ID from the newly corrected point data set?
I have tried using select by attribute and expression but it does not like the comma separating the values and will only search for one value for me at a time.
I think if '' was added to each number and an OR operator was placed in between each of them this would work in 'select by attribute' but unfortunately I am not aware of how to do this.
I am using QGIS 2.18 on windows 10