보미네

$tempResults =  'filelist1.txt' 
Set-Content -Path $tempResults -Value 'Path\Name.Extension, FileSize' -Encoding UTF8

foreach( $file in (Get-ChildItem -File -Path 'C:\path' -Recurse) )
{
    $nameCount = Get-Content -Path $file.FullName -Encoding UTF8 | Select-String -Pattern 'userFindString' | Measure-Object | Select-Object -ExpandProperty Count

    if( $nameCount -gt 0 )
    {
                $line =  $file.DirectoryName + '\' + $file.BaseName + $file.Extension + ' ' + $file.Length + ' ' + $file.CreationTime
        Add-Content -Path $tempResults -Value $line -Encoding UTF8
    }
}
clear 
type $tempResults
#notepad $tempResults
remove-item $tempResults

SELECT 
	ISNULL(TRIM(',' FROM STRING), ''), -- 왼쪽 오른쪽 다 날리기
	ISNULL(LTRIM(RTRIM(STRING,','),','), ''), -- 왼쪽 오른쪽 다 날리기 
	STUFF(STRING,1,1,''), -- 첫 문자 하나만 날리기
	ISNULL(SUBSTRING (STRING, 2, NULLIF(LEN(STRING)-1,-1)), ''), -- 첫 문자 하나만 날리기
	ISNULL(SUBSTRING (STRING, 1, NULLIF(LEN(STRING)-1,-1)), '')  -- 마지막 문자 하나만 날리기 
FROM 
	( 
	  VALUES 
	  (NULL)   
	, ('1,2')   
	, (',,1,2,,,')
	, (',1,2')   
	, ('1,2,')   
	) A (STRING)