- 论坛徽章:
- 0
|
awk 'BEGIN {
FS=","
}
{
for(i=1; i<=NF; i++){
if(i<26){
printf("%s,", $i)
}else{
j=(i-25)%3
if(j!=0){
printf("%s.", $i)
}else{
tail=sprintf("%s%s", tail, $i)
}
}
}
printf("%s\n", tail);
tail=""
}
END {}' $INPUTFILE.r> dst1
awk 'BEGIN {
FS="."
}
{
for(i=1; i<NF-1; i++){
printf("%s.", $i)
}
printf("%s,%s\n", $(NF-1), $NF)
}
END {}' dst1 > dst2
################################################
#awk 'BEGIN {
# FS=","
# }
#
# {
# printf("%s\n", $(NF-1))
# }
#
# END {}' dst2 > src1
#
#sed 's/[^ ]\{24\}/&,/g' src1 > dst3
################################################
awk 'BEGIN {
FS=","
}
{
for(i=1; i<NF-1; i++){
printf("%s,", $i)
}
for(j=0;j<length($(NF-1)); j++){
val[j]=substr($(NF-1), j+1, 1)
}
m=0
for(n=0;n<j;n++){
rlt[m++]=val[n]
if((n+1)%24==0){
rlt[m++]=","
}
}
for(k=0;k<m;k++)
printf("%c", rlt[k])
printf(",%s\n", $NF)
}
END {}' dst2 > dst3
awk 'BEGIN {
FS=","
}
{
for(j=1; j<=25; j++){
printf("%s,", $j)
}
partten="[.]"
replace="."
for(i=26; i<NF; i++){
num=gsub(partten, replace, $i)
if(num>4){
printf("%s", $i)
}else{
printf("%s,", $i)
}
}
printf(",%s\n", $NF)
}
END {}' dst3 > dst4
awk 'BEGIN {
FS="."
}
{
ch=","
flag=0
for(i=1; i<NF; i++){
if(index($i, ch)!=0){
printf("%s.", $i)
flag=1
}else{
if(i%4==0){
if(flag==1){
printf("%s,", $i)
flag=0
}else{
printf("%s,", $i)
}
}else{
printf("%s.", $i)
}
}
}
printf("%s\n", $NF)
}
END {}' dst4 > dst5
################################################
#val=`awk 'BEGIN {}
#
# {
# for(i=1; i<=NF; i++)
# printf("%s ", $i)
# }
#
# END {}' dst5`
#
#awk -v val=$val 'BEGIN {
# FS=","
# }
#
# {
# ch=" "
# nxt=index(val, ch)
# vali=substr(val, pre, nxt-pre)
# pre=nxt
# valr=substr(val, pre, length(val)-pre)
# val=valr
# for(i=1; i<=NF; i++){
# if(i==NF-1)
# printf("%s", vali)
# else
# printf("%s,", $i)
# }
# }
#
# END {}' dst2 >> $OUTPUTFILE
awk 'BEGIN{
FS =","
OutputFmt="%-10s%-20s%-4s%-4s%-20s%-20s%-20s%-25s20%-25s20%-18s%-6s%-8s%-4s%-8s%-15s%-15s%-8s%-5s%-15s%-15s%-10s%-15s%-15s%-8s%-8s%-24s%-24s%-24s%-24s%-24s%-10s\n"
}
{
printf(OutputFmt,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28,$29,$30,$31)
}
END{}' dst5 > $OUTPUTFILE |
|