Jeff Moden (8/30/2015)
JoseMenendez (8/29/2015)
The name can be, but will not always be the 2nd word in the string. It will be 1 of 8 names, and if none of those names are found in the string it should be unknown. Does that help make it a little clearer?Yes, that makes it more clear but whatever is creating the data knows what's happening and who did it. It would be a thousand times better if the action and the name were created in separate columns by whatever is logging the data... especially since there's likely going to be more than one Mark in the world that could join your company in the future.
Agreed, just looking for a "pretty" way to display the data until information is able to be back-filled, as the front-end application has already been updated to prevent this from occurring. Now the data just needs to be updated to mirror.