Hello all, this is my first post on this forum!
I am working on research into fungal rarity, hoping soon to publish my first paper.
I have data that looks like this:
Leptosphaeria agnita
NZ3513
NZ81
SD4774
SD4777
SE2773
SE3742
SE5612
SE8584
SO5615
SO5911
SO5914
SO5918
SO6018
SO6414
SO8913
SO8914
SP8151
SP863538
..and I need it to look like this:
Leptosphaeria agnita
NZ35
NZ81
SD47
SD47
SE27
SE37
SE56
SE85
SO56
SO59
SO59
SO59
SO60
SO64
SO89
SO89
SP81
SP86
I have run into a problem with the grid reference column of my species list. I need unique 10km square grid refs. A 10km grid ref is two letters followed by two numbers. More numbers means a higher accuracy, for example two letters with six numbers means an accuracy of 100m. The issue is that I have a set of 'unique grid refs, but when they are trimmed to the 10km square standard, you can see there are many duplicates!
So does anyone know how I can efficiently trim my grid ref column down to the two letter two number format which I need?
All the best!
Bookmarks