Forum Discussion
ColinL965
Sep 08, 2022Copper Contributor
Sort function
Trying to figure out a sort on a table. my problem is as follows. a column contains serial no's . There are wrongly entered serial no's ( without a prefix ) eg. SN12345 = Correct, 12345 = Inc...
Riny_van_Eekelen
Sep 08, 2022Platinum Contributor
ColinL965 Would it work if you created a new column that fixes the issue of the incorrect serial numbers. Something like this:
ColinL965
Sep 08, 2022Copper Contributor
Each entry in the table is unique. At this stage i dont want to alter any of the data, just bring entries together for later deletion from a main database. For further information this table has been exported from a much larger database, which i cannot modify directly or import back to.