(Simplified)
I have a list of full name Strings. The first 6 characters are the first name always.
List<string>()
fredXXsmith
aliceXFloor
billXXjohnson
fredXXperterson
How can I get the list of unique first names from these strings in LINQ?
fredXX
aliceX
billXX