Home Forums SQL Server 2005 T-SQL (SS2K5) split column into multiple records based on substring fixed lenght RE: split column into multiple records based on substring fixed lenght

  • December 12, 2013 at 10:34 am

    #1673029

    Richard Cranston (12/12/2013)

    So I was able to split column based on specific substring length and export the data to my target source; at which point I noticed data contained Line Feed.

    So is there a way to split column into multiple records based on Line Feed and excluding Line Feed char(10)

    Thanks again in advance for your help.

    See Jeff Moden's splitter at http://www.sqlservercentral.com/articles/Tally+Table/72993/

    and use CHAR(10) as the delimiter

    Far away is close at hand in the images of elsewhere.
    Anon.