Single quotes logparser

PowerShell Help
1

Hi

i am searching a string in IIS Logs, i am parsing this through Logparser. The Logparser throws an error when ever the string has a single quotes with in it.
sample code

SELECT To_lowercase(cs-uri-stem) as URL, count(URL), MAX(Date)
FROM ‘[LOGFILEPATH]’
WHERE URL LIKE ‘String’s url’ AND cs-username is not NULL
GROUP BY URL

the script works fine if the string has no single quotes in it. but i am not sure how can i make this work if it has a single quotes in the string. can anyone help me out?

Regards
Lokesh

2

Quick search turned this up: Apostrophe Excape Need in Folder Path - Using Log Parser as an object in vbscript

If that does indeed work, then you should be able to escape your strings with this bit of PowerShell:

$someText = "This string's got an apostrophe in it."
$someText = $someText -replace "'", '\u0027'
3

it works dave

Thankyou

Regards
lokesh