Post reply

Please help to get the data from 3rd to 4th under score i.e 20200912175059319

  • August 8, 2022 at 5:11 pm

    #4074057

    organisationneyes.wsd.md_1_1_20200912175059319_a86d1d549e1cafcf.jpg

    from above string Please help to get the data from 3rd under score to 4th underscore  i.e like 20200912175059319

    Thank you for the help in advance

  • August 8, 2022 at 9:38 pm

    #4074148

    You can read THIS ARTICLE on Splitter functions by Jeff Moden.

    At the end of the article, you will find a link "The New Splitter Functions.zip" that will allow you to download the source code for DelimitedSplit8K.  Install this function, and use as follows

    /*
    Extract from a variable
    */
    DECLARE @FileName VARCHAR(255) = 'organisationneyes.wsd.md_1_1_20200912175059319_a86d1d549e1cafcf.jpg'

    SELECT [FileName] = @FileName, FileDateTime = splt.Item
    FROM dbo.DelimitedSplit8K(@FileName, '_') AS splt
    WHERE splt.ItemNumber = 4;
    /*
    Extract from a table
    */
    DECLARE @YourTable TABLE (ID INT IDENTITY(1,1) NOT NULL, FileName VARCHAR(255) NOT NULL);

    INSERT INTO @YourTable(FileName)
    VALUES ('organisationneyes.wsd.md_1_1_20200912175059319_a86d1d549e1cafcf.jpg')

    SELECT src.*, FileDateTime = splt.Item
    FROM @YourTable AS src
    CROSS APPLY dbo.DelimitedSplit8K(src.FileName, '_') AS splt
    WHERE splt.ItemNumber = 4;

    How to post data/code on a forum to get the best help.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply