Like function problem

pfm200586 · #1 (**permalink**) 10-28-11, 13:54

hello everyone,

I am trying to check each letter of a word if that word doesn't contain (AEIOUY) then I have to append (-way) to the end of the word. Now I have this if statement and it doesn't work:

If OriginalWord.ToUpper Like "*[!AEIOUY]*" Then
Label1.Text = OriginalWord & "-way"
End If
any suggestion to make it work. I need to append a (-way) to the end of a word that doesn't have (AEIOUY)

thank you guys

Regards

rokslide · #2 (**permalink**) 10-30-11, 16:56

Is this in classic Visual Basic? Or VB.Net or are you trying to do this in SQL? Assuming you are using VB.Net have a look at these examples

Code:

        Console.WriteLine(("DFGHJKL" Like "[AEIOUY]")) 'False
        Console.WriteLine(("DFGAHJKL" Like "*[AEIOUY]*")) 'True
        Console.WriteLine(("EFGHJKL" Like "[AEIOUY]*")) 'True
        Console.WriteLine(("FGHJKLI" Like "*[AEIOUY]")) 'True
        Console.WriteLine(("OFGHJKL" Like "*[AEIOUY]*")) 'True
        Console.WriteLine(("FGHJKLU" Like "*[AEIOUY]*")) 'True
        Console.WriteLine(("DFGHJKL" Like "![AEIOUY]")) 'False
        Console.WriteLine(("DAJKL" Like "![AEIOUY]")) 'False
        Console.WriteLine(("DFGAEKL" Like "![AEIOUY]"))  'False
        Console.WriteLine(("DFARETIWOVUBYJKL" Like "![AEIOUY]")) 'False

The way the like works with the ! operator and a character list is non-intuative. I would actually recommend doing a check in this manner... which I haven't tested but I think should work

Code:

If (!(OriginalWord.ToUpper Like "*[AEIOUY]*")) Then
    Label1.Text = OriginalWord & "-way"
End If

Internet Services

Web Development

Digital Marketing

Consumer Tech