filter awk ([scriptblock] $cmd = $args[0], [regex] $delimiter='\s+')
{
$line = @($delimiter.split($_.Trim()));
$countOfBlock = $line.length;
$0 = $_;#input from pipeline
for ($i = 1; $i -le $countOfBlock; $i++)
{
Invoke-Expression "`$$i = '$($line[$i - 1])'"
}
& $cmd
}
cls
$hash = @{}
cd "C:\Documents and Settings\jz20247\Desktop\self\task\powershell\test"
gc file2.txt | awk -cmd {$hash[$1.substring(1,4)] = $2}
gc file1.txt | awk -cmd { "$0 $($hash[$1.substring(0,4)])" }
cls
cd "C:\archived\self\task\20100719 Migrate\c"
Get-Date
Get-Content "sqlLippsFile.txt" -ReadCount 1| %{`
foreach($item in $_)
{
$value = $item.Trim()
if($value -notlike "cusip*" -and $value -notLike "----*" -and $value -ne [string]::Empty)
{
$value = $value -replace '\s+', "`t"
echo $value
}
}}| Out-File -encoding ascii -FilePath 3.txt
Get-Date