I have a Power Query/M question. I have a list of full names, some of which have middle initials (without a period) and some of which do not. Names (and the possible initial) are delimited by spaces. Some of the names have multiple first or last names which I would want to keep. So you might have a mix of names like
John Smith
John Q Smith
Maggie Q Smith
Anne Margaret Smith
Ann Margaret Q Smith
Anne Margaret Nixon Smith
I would like to return all the names but not the initials. In other languages I would use regex but I cannot do so in PQ, and I'm just beginning to learn M. Has anyone come across something similar?
