Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Extract Text around comma and space into other columns RE: Extract Text around comma and space into other columns

  • February 7, 2018 at 7:16 am

    #1978871

    sestell1 - Tuesday, February 6, 2018 1:52 PM

    There could be spaces in the last name as well...  combined names (Smith, Jim & Donna)... etc...
    Without fixed delimiters you can rely on, I suspect you'll find a never ending list of edge cases and bad data and could spend the rest of your life trying to get 100%.
    The best option would be to push back on the vendor to send you the data parsed out instead of combined if you really need the name elements split out.

    I sent an email to the vendor (a fairly large health insurance company) asking if this is feasible.  Everyone else does it that we work with.  
    In the meantime, Excel is quick enough at splitting them out for me, while I learn how to do it with T-SQL.

    -Mark
    MSSQL 2019 Standard, Azure Hosted. Techie/Sysadmin by trade; Three years as a "DBA" now.