none
Split one String into Multiple Columns RRS feed

  • Question

  • Hi Developers 

    hope all is well 

    i just want to understand something 

    i have one column that has a string length 

    Example of the data set below 

    Data Set 
    If I take this route ill get there quicker

    Now what i need to do is take that string and split it into three columns, however it needs to be split into those three columns based on 14 characters

    Output1 Output2 Output3
         

    is this achievable, i need to understand how is this possible

    Thursday, November 12, 2020 8:13 AM

All replies

  • Hi Ronald

    This forum is dedicated to supporting issues related to open specification. You can access open specifications at https://docs.microsoft.com/en-us/openspecs/. Your inquiry does not seem to be related to open specifications.

    For a better chance of getting an answer to your question, you may want to post your question to the following forum: https://docs.microsoft.com/en-us/answers/products/sql-server


    HungChun Yu (MSFT)

    Thursday, November 12, 2020 3:48 PM