I have a field that lists the last name, first name, middle or middle initial with a period all in one cell, Examples Given:
Lager, Curtis A.
Lager, Curtis Adrian
Lager, Sr, Curtis A.
Lager Curtis Adrian, Sr.
The staff is not consistent except for the last name. I want to create a query that does the opposite of “concatenation”, breaking down (splitting) this text field by using the comma, period and space as dividers. I know of the Right and Left and Trim, however each name has a different number of characters. Can this be accomplished in Access and if so, can you provide a sample? Thanks.
Lager, Curtis A.
Lager, Curtis Adrian
Lager, Sr, Curtis A.
Lager Curtis Adrian, Sr.
The staff is not consistent except for the last name. I want to create a query that does the opposite of “concatenation”, breaking down (splitting) this text field by using the comma, period and space as dividers. I know of the Right and Left and Trim, however each name has a different number of characters. Can this be accomplished in Access and if so, can you provide a sample? Thanks.