Home IIS.NET Forums Logparser Forums Input Formats Select ONLY the text that BEGINS with a given letter
Last post Jun 30, 2014 10:16 AM by g_cory
62 Posts
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?
368 Posts
Jun 30, 2014 10:16 AM|g_cory|LINK
SELECT * FROM table WHERE name LIKE '[Z]%'
62 Posts
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?
368 Posts
Re: Select ONLY the text that BEGINS with a given letter
Jun 30, 2014 10:16 AM|g_cory|LINK
Please "Mark" as Answer if this post helped you.
OrcsWeb: Managed Windows Hosting Solutions
"Remarkable Service. Remarkable Support."