Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Substring! HELP

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:

    MATTHIEU FOURNIER
    Computacenter AG & Co oHG
    KPMG
    WA DET
    LENOVO
    WOOLWORTHS LIMITED
    LENOVO C/O DHL Supply Chain
    Deutsche Telekom / T-Systems

    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!

  • #2
    Re: Substring! HELP

    Hello,

    You can test following formula

    Code:
    =Match("*"&"Fournier"&"*",YourReferenceRange,0)
    Hope this will help
    To say "Thank You" for the help received ...Just click on the "Like" icon ...underneath ... ... in the bottom right corner ...

    Comment

    Trending

    Collapse

    There are no results that meet this criteria.

    Working...
    X