This is an on going project. I take comma delimited files and import the data into tables. This has been a big problem separating this field out. ...

The files that I receive are usually in rough shape. The most common way the files I receive have a full name in the first column i.e. Doe,John J...