idwma

powershell "(type a.csv) -replace '^(.*?,)(.*?):(.*?)(,.*?,.*?,.*?,.*?,.*?,.*?,.*?,.*?,)(.*?)(,.*)$','$1$3$4$2$6'" >b.csv
复制代码

idwma

回复 3# 司马光2008

powershell "dir D:\123\*.csv|foreach{out-file -enc default D:\456\$_.name -inp ((type $_.fullname) -replace '^(\d*?,)(.*?):(.*?)((?:,.*?){8},)(.*?)(,.*)$','$1$3$4$2$6');del $_.fullname}"
复制代码

idwma

#@&cls&powershell "type %~s0|out-string|iex"&pause&exit
dir D:\123\*.csv|foreach{
$a="D:\456\"+$_.name
out-file -enc default $a -inp ((type $_.fullname) -replace '^(\d+?,)(.*?):(.*?)(,.*?,.*?,.*?,.*?,.*?,.*?,.*?,.*?,)(.*?)(,.*)$','$1$3$4$2$6')
del $_.fullname
}
复制代码

idwma

回复 9# 司马光2008

#@&cls&powershell "type %~s0|out-string|iex"&pause&exit
do{
    dir D:\123\*.csv|foreach{
        $a="D:\456\"+$_.name
        out-file -enc default $a -inp ((type $_.fullname) -replace '^(\d+?,)(.*?):(.*?)(,.*?,.*?,.*?,.*?,.*?,.*?,.*?,.*?,)(.*?)(,.*)$','$1$3$4$2$6')
        del $_.fullname
    }
}while(!(sleep 1))
复制代码

idwma

换一种方式

#@&cls&powershell "type %~s0|out-string|iex"&pause&exit
do{
    dir D:\123\*.csv|foreach{
        $a="D:\456\"+$_.name
        move $_.fullname D:\456\
        if($?){
            $b=type $a
            sc $a ($b -replace '^(\d+?,)(.*?):(.*?)(,.*?,.*?,.*?,.*?,.*?,.*?,.*?,.*?,)(.*?)(,.*)$','$1$3$4$2$6')
        }
    }
}while(!(sleep 1))
复制代码

idwma

回复 17# 司马光2008

#@&cls&powershell "type %~s0|out-string|iex"&pause&exit
do{
    dir D:\123\*.csv|foreach{
        $a="D:\456\"+$_.name
        move $_.fullname $_.fullname 2>$null
        if($?){
            sc $a ((type $_.fullname) -replace '^(\d+?,)(.*?):(.*?)(,.*?,.*?,.*?,.*?,.*?,.*?,.*?,.*?,)(.*?)(,.*)$','$1$3$4$2$6')
            del $_.fullname
        }
    }
}while(!(sleep 1))
复制代码