Select ONLY the text that BEGINS with a given letterRSS

1 reply

Last post Jun 30, 2014 10:16 AM by g_cory

  • Select ONLY the text that BEGINS with a given letter

    Sep 05, 2013 12:47 PM|hg363|LINK

    Let’s say I have the following data in a text file

    Z

     

    ZENworks Asset Management - Client Apps

     

    Microsoft Internationalized Domain Names Mitigation APIs

     

    FileZilla Client 3.6.0.2 --Version: 3.6.0.2

     

    7-Zip 9.20

     

    hpzTLBXFX --Version: 002.002.00170

     

    Mozilla Firefox 23.0.1 (x86 en-GB) --Version: 23.0.1

     

    hpzTLBXFX --Version: 004.014.00150

     

    ZyXEL G-302 v3  Utility --Version: 3.00

     

    EasyZip

     

     

    What would be the correct Log Parser query to select ONLY THE TEXT BEGINNING WITH THE LETTER Z

    Would some one kindly provide me with an example?

  • Re: Select ONLY the text that BEGINS with a given letter

    Jun 30, 2014 10:16 AM|g_cory|LINK

    SELECT * FROM table WHERE name LIKE '[Z]%'


    Cory Granata
    Please "Mark" as Answer if this post helped you.

    OrcsWeb: Managed Windows Hosting Solutions
    "Remarkable Service. Remarkable Support."