＠WIKI
シェルサンプル
最終更新：
atyou
-
view
find . -name '*.*' |xargs grep -n 'KeyWord' >wk
find . -name '*.*' |xargs grep -l 'KeyWord'
s/^\s*|\s*$//g;
BEGIN {
FS=",";
print "spool nayose2.txt";
}
{
#gsub(/^ +/,"",$3);
gsub(/ +$/,"",$3);
#gsub(/^ +/,"",$4);
gsub(/ +$/,"",$4);
if ( $3 == "" ) $3= " ";
if ( $4 == "" ) $4= " ";
printf ("UPDATE テーブルA SET カナ名 ='%s', 漢字
名 ='%s' , 本名有無FLG = 1 WHERE 店番 =%s AND 顧客番号
=%s;\n",$3,$4,$1,$2)
}
END {
print "spool off";
}
find . -name '*.*' |xargs grep -l 'KeyWord'
s/^\s*|\s*$//g;
BEGIN {
FS=",";
print "spool nayose2.txt";
}
{
#gsub(/^ +/,"",$3);
gsub(/ +$/,"",$3);
#gsub(/^ +/,"",$4);
gsub(/ +$/,"",$4);
if ( $3 == "" ) $3= " ";
if ( $4 == "" ) $4= " ";
printf ("UPDATE テーブルA SET カナ名 ='%s', 漢字
名 ='%s' , 本名有無FLG = 1 WHERE 店番 =%s AND 顧客番号
=%s;\n",$3,$4,$1,$2)
}
END {
print "spool off";
}
