木叶知秋 发表于 2015-11-14 18:37
最近超爱正则表达式,供参考~
data testh;
infile "C:\Users\Administrator\Desktop\test.txt" lrecl=100 truncover;
input strings $100.;
run;
data test2(keep=name phone_num date);
length name phone_num date $20.;
if _n_=1 then pattern=prxparse('/\"(.+)\",(\"(\d{11,})\")?,\"([\w\-]+)\"/o');
retain pattern;
set testh;
rc=prxmatch(pattern,strings);
name=prxposn(pattern,1,strings);
phone_num=prxposn(pattern,3,strings);
date=prxposn(pattern,4,strings);
run;
亲,再麻烦你一下,我想用正则表达式读取这个数据,为什么第二个观测值读不进去?希望指导一下,三克油!
原数据:"steinberg","18088888888","2015-11-21"
"henhh", "2019-11-21"