Substring! HELP

  • Hi all, i need some help regarding SQL.


    i have a column in a table (let's say A.) which contains data like this:


    [TABLE="width: 313"]

    [tr]


    [TABLE="width: 313"]

    [tr]


    [TD="width: 313"]Ship To Name
    [/TD]

    [/tr]


    [/TABLE]

    [/tr]


    [tr]


    [td]

    MATTHIEU FOURNIER

    [/td]


    [/tr]


    [tr]


    [td]

    Computacenter AG & Co oHG

    [/td]


    [/tr]


    [tr]


    [td]

    KPMG

    [/td]


    [/tr]


    [tr]


    [td]

    WA DET

    [/td]


    [/tr]


    [tr]


    [td]

    LENOVO

    [/td]


    [/tr]


    [tr]


    [td]

    WOOLWORTHS LIMITED

    [/td]


    [/tr]


    [tr]


    [td]

    LENOVO C/O DHL Supply Chain

    [/td]


    [/tr]


    [tr]


    [td]

    Deutsche Telekom / T-Systems

    [/td]


    [/tr]


    [/TABLE]



    what i need is to be able to identify names from those lines, for example Fournier only and look for that name in another table( B), if there is a match then select the match from the table B and fill another column from table A.


    it's something like the fuzzylookup from excel.


    problem: i do not know when the name is going to appear, i do not know the lenght nor the start. it could be in the middle, start or end.


    do you know if this is going to have any kind of solution? i've tried with the substring, however it's not solving my problem.


    thanks in advance!

  • Re: Substring! HELP


    Hello,


    You can test following formula


    Code
    1. =Match("*"&"Fournier"&"*",YourReferenceRange,0)


    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Like" icon ...just below...in the bottom right corner...:)