天软金融分析.NET函数大全 > TSL函数 > 基础函数 > 数组 > 数组操作

FrameGetSubByReg    

简述
通过正则表达式匹配获取数据框子集
   对于数字下标,通过转为字符串后,继续正则匹配,但最后的结果数字下标会改变,且多个数字下标会按照从小到大的顺序排序,从0开始
定义
frameGetSubByReg (Data:array; reg:string):array
参数
名称类型说明
Dataarray数组,待匹配的数组
当Data为数据表时,匹配列名
当Data为一维数组时,匹配行名
regstring字符串,间隔名,正则匹配串
返回array数组,匹配的子集
  • 范例

    T :=array((13:1,"V1":1,"V2":11,12:21,'R1w':1),
         (13:0,"V1":2,"V2":12,12:22,'R1w':1),
         (13:1,"V1":3,"V2":13,12:23,'R1w':1),
         (13:0,"V1":4,"V2":14,12:24,'R1w':1),
         (13:1,"V1":5,"V2":15,12:25,'R1w':1),
         (13:0,"V1":6,"V2":16,12:26,'R1w':1));
    return frameGetSubByReg(T,'1');

    //结果:
    array(
    (21,1,"V1":1,"R1w":1),
    (22,0,"V1":2,"R1w":1),
    (23,1,"V1":3,"R1w":1),
    (24,0,"V1":4,"R1w":1),
    (25,1,"V1":5,"R1w":1),
    (26,0,"V1":6,"R1w":1))
相关