I have a field that has the first, last and Middle Initial fields combined together. They are somewhat space delimited. I would like to separate only the Middle Initial in a separate field using the IIF function.
The data is like this
Smith John S
D Marco Tom L
Van Rros Mike B
My theory was to evaluate the Last-1 if = space, then Middle_Initial = Last.