求助大神一个时间替换问题

Herowinter

同一行中会出现2个数据吗？比如
year=<{y1}> AND month=<{m1}> AND day=<{d1}> year=<{y2}> AND month=<{m2}> AND day=<{d2}>
在一行中。

闸北陆小洪

回复 11# Herowinter

有可能的  因为这是用户输入的  你只能告诉用户"我会把你输入的<{dx}>替换为x天之前的日"

别的你无法控制用户的输入   这就是需要<{}>的用处


   

Herowinter

回复 12# 闸北陆小洪
新手表示难度太高，单行还勉强可以，多行模式不大会，
输入不规范的话，还可能出现这种
year=<{y1}> AND month=<{m1}> AND day=<{d1}> year=<{
y2}> AND month=<{m2}> AND day=<{d2}>

这可如何是好？
坐等大神解答了


   

jason680

回复 1# 闸北陆小洪

How about this

$ echo "year=<{y1}> AND month=<{m1}> AND day=<{d1}>" | awk -F'[{}]' 'function get_ymd(n,k,T){split("ymd",ymd,"");for(k in ymd){if(sub("^"ymd[k],"",n)){t=systime()-86400*n;return(strftime("%"ymd[k],t) + ((ymd[k]=="y")?2000:0))}}return n}{for(n=0;n++<NF;){if(!(n%2))$n=get_ymd($n);printf("%s",$n)}print""}'
year=<2013> AND month=<11> AND day=<25>

$ echo "year=<{y1}> AND month=<{m1}> AND day=<{d1}>" | perl -lape 'BEGIN{%ymd=("y",5,"m",4,"d",3)}{s/\{([ymd])(\d+)\}/(localtime(time-86400*$2))[$ymd{$1}]+{"y",1900,"m",1,"d",0}->{$1}/ge}'
year=<2013> AND month=<11> AND day=<25>

   

Herowinter

只会写这种，单行比较格式化的数据。
输入文件i  输出文件i1

1. #!/bin/bash
   
2. 
   
3. if [ -f i1 ]; then
   
4.   rm i1
   
5. fi
   
6. 
   
7. while read line
   
8. do
   
9. 
   
10. n=$(echo $line | awk -F' AND ' '{yn=gensub(/year=<{y([0-9]+)}>/,"\\1",1,$1);mn=gensub(/month=<{m([0-9]+)}>/,"\\1",1,$2);dn=gensub(/day=<{d([0-9]+)}>/,"\\1",1,$3);print yn,mn,dn}')
    
11. 
    
12. yn=$(echo $n | awk '{print $1}')
    
13. mn=$(echo $n | awk '{print $2}')
    
14. dn=$(echo $n | awk '{print $3}')
    
15. 
    
16. year=$(date --date "$yn days ago" +%Y)
    
17. month=$(date --date "$mn days ago" +%m)
    
18. day=$(date --date "$dn days ago" +%d)
    
19. 
    
20. echo "year=<{$year}> AND month=<{$month}> AND day=<{$day}>">>i1
    
21. 
    
22. done <i
    
23. 
    
24. 
    
25. cat i
    
26. year=<{y1}> AND month=<{m1}> AND day=<{d1}>
    
27. year=<{y365}> AND month=<{m31}> AND day=<{d2}>
    
28. 
    
29. cat i1
    
30. year=<{2013}> AND month=<{11}> AND day=<{25}>
    
31. year=<{2012}> AND month=<{10}> AND day=<{24}>
    

复制代码

rulebook

s="year=<{y1}> AND month=<{m1}> AND day=<{d1}>"
eval `echo $s | egrep -o "<[^<>]+>" | tr -d "<>{}" | xargs -I{} echo {} | awk '/y/{num=sub(/[a-z]/,"");"date +%Y -d-"num"year" | getline t;print "y="t} /m/{num=sub(/[a-z]/,"");"date +%m -d-"num"month" | getline t;print "m="t} /d/{num=sub(/[a-z]/,"");"date +%d -d-"num"day" | getline t;print "d="t}'`
echo $s | sed -r "s/<\{y[0-9]\}>/$y/g; s/<\{m[0-9]\}>/$m/g; s/<\{d[0-9]\}>/$d/g"

闸北陆小洪

试了是多种方法  太麻烦了  换java了

多谢各位

shintoky

回复 17# 闸北陆小洪
用Perl:

#!/usr/bin/perl
while ($S=<>){
while ($S =~ m/(<{(\D)(\d+)}>)/g){
my $match = $1;
my $y = $2;
my $n = $3;
my $time = `date +%$y --date='$n days ago'` ;
$S =~ s/$match/$time/;
$S =~ s/\n//g;
}
print "$S\n";
}