В ряде строк (251803, 415774 и т.д.) банально отсутствуют значения в поле документа. Вследствие этого
корректная работа с ним невозможна никаким методом.
А так, вот Вам пример работы с LIKE. Пакетный файл:
читать дальше »
Код:
@echo off
setlocal enableextensions enabledelayedexpansion
set sSourceFile=E:\Песочница\0344\document_statistics.txt
set sFromDateTime=2013-12-01
set sToDateTime=2013-12-31
set sPartDocumentID=rsl01003399443.pdf
"%ProgramFiles%\Log Parser 2.2\LogParser.exe" file:"Query - By Part of DocumentID.sql"?SourceFile=%sSourceFile%+FromDateTime=%sFromDateTime%+ToDateTime=%sToDateTime%+PartDocumentID=%sPartDocumentID% -i:TSV -iSeparator:space -nSkipLines:2 -headerRow:OFF -iCodepage:65001 -stats:OFF -rtp:-1
endlocal
exit /b 0
Query - By Part of DocumentID.sql:
читать дальше »
Код:
SELECT
[Date],
[Document ID],
[Action],
[Page],
[Succeeded],
[IP],
[User ID],
[Extra]
USING
TO_TIMESTAMP(STRCAT(STRCAT(Field1, ' '), Field2),'yyyy-MM-dd hh:mm:ss.ll') AS [Date],
Field3 AS [Action],
Field4 AS [Document ID],
Field5 AS [Page],
Field6 AS [Succeeded],
Field7 AS [IP],
Field8 AS [User ID],
Field9 AS [Extra]
INTO DATAGRID
FROM '%SourceFile%'
WHERE
[Document ID] LIKE '%%%PartDocumentID%' AND
[Date] BETWEEN TO_TIMESTAMP('%FromDateTime%', 'yyyy-MM-dd') AND TO_TIMESTAMP('%ToDateTime%', 'yyyy-MM-dd')
ORDER BY [Date]
