Home > Software design >  Need to extract 2 values in a single expression using regular expression in Jmeter
Need to extract 2 values in a single expression using regular expression in Jmeter

Time:08-24

Here's my input:

[{affectedRows:0,data:[{dotprojectseqnum:1,brandName:"Curries",companyId:166,newOrExisting:"Imported",projectCode:"230822_5",projectDesc:"AMBER POCASSET HIGH SCHOOL",framePoNumber:"8700",lastchange:new Date(1661252342997),masterProject:"Not Assigned to Any",projectId:149235,rowID:1},{dotprojectseqnum:2,brandName:"Curries",companyId:166,newOrExisting:"Imported",projectCode:"230822_1",projectDesc:"AMBER POCASSET HIGH SCHOOL",framePoNumber:"8123",lastchange:new Date(1661252330273),masterProject:"Not Assigned to Any",projectId:149234,rowID:2},{dotprojectseqnum:0,brandName:"Curries",companyId:166,newOrExisting:"Imported",projectCode:"230822_3",projectDesc:"AMBER POCASSET HIGH SCHOOL",framePoNumber:"1064892",lastchange:new Date(1661252328280),masterProject:"Not Assigned to Any",projectId:149233,rowID:3},{dotprojectseqnum:1,brandName:"Curries",companyId:166,newOrExisting:"Imported",projectCode:"CuLoTestFR5",projectDesc:"AMBER POCASSET HIGH SCHOOL",framePoNumber:"3589",lastchange:new Date(1661204993723),masterProject:"Not Assigned to Any",projectId:149228,rowID:4},{dotprojectseqnum:2,brandName:"Curries",companyId:166,newOrExisting:"Imported",projectCode:"CuLoTestDR2",projectDesc:"AMBER POCASSET HIGH SCHOOL",doorPoNumber:"6539",framePoNumber:"9132",lastchange:new Date(1661204974390),masterProject:"Not Assigned to Any",projectId:149227,rowID:5},{dotprojectseqnum:0,brandName:"Curries",companyId:166,newOrExisting:"Imported",projectCode:"CuLoTestFR3",projectDesc:"AMBER POCASSET HIGH SCHOOL",framePoNumber:"1066892",lastchange:new Date(1661204971227),masterProject:"Not Assigned to Any",projectId:149226,rowID:6},{brandName:"Curries",ppof:"Y",newOrExisting:"New",rowID:7,dotprojectseqnum:0,companyId:166,projectCode:"ppof28",imported:"N",projectDesc:"jkj",lastchange:new Date(1640697895847),masterProject:"Not Assigned to Any",projectId:144412,selected:0},{brandName:"Curries",ppof:"Y",newOrExisting:"New",rowID:8,dotprojectseqnum:0,companyId:166,projectCode:"12272021",imported:"N",projectDesc:"PPOF ",lastchange:new Date(1640659904817),masterProject:"Not Assigned to Any",projectId:144385,selected:0},{brandName:"Curries",ppof:"Y",newOrExisting:"New",rowID:9,dotprojectseqnum:0,companyId:166,projectCode:"2-10-21",imported:"N",projectDesc:"PPOF",lastchange:new Date(1613013416263),masterProject:"Not Assigned to Any",projectId:130500,selected:0}],endRow:9,invalidateCache:false,isDSResponse:true,operationType:"fetch",queueStatus:0,startRow:0,status:0,timing:{name:"Server processing",start:1661245642852,children:[{name:"RPCManager construction",start:1661245642852,children:[{name:"DSRequest construction",start:1661245642912,children:[],end:1661245642917}],end:1661245642917},{name:"RPCManager processing",start:1661245642917,children:[{name:"DSRequest processing",start:1661245642917,children:[{name:"groupBy processing",start:1661245642917,children:[],end:1661245642917},{name:"includeFrom processing",start:1661245642917,children:[],end:1661245642917},{name:"Declarative security checks",start:1661245642917,children:[],end:1661245642917},{name:"Field-level declarative security checks",start:1661245642917,children:[],end:1661245642917},{name:"Prepare DSRequest for DMI",start:1661245642917,children:[],end:1661245642917},{name:"DMI",start:1661245642917,children:[],end:1661245642917},{name:"transformMultipleFields processing",start:1661245642917,children:[],end:1661245642917},{name:"Rowcount query",start:1661245642917,children:[{name:"Unpaged fetch",start:1661245642917,children:[{name:"get connection",start:1661245642917,children:[],end:1661245642917},{name:"query",start:1661245642917,children:[],end:1661245642957},{name:"SQLTransform",start:1661245642957,children:[],end:1661245642957}],end:1661245642957}],end:1661245642957},{name:"Paged fetch",start:1661245642957,children:[{name:"get connection",start:1661245642957,children:[],end:1661245642957},{name:"query",start:1661245642957,children:[],end:1661245643017},{name:"SQLTransform",start:1661245643017,children:[],end:1661245643017}],end:1661245643017}],end:1661245643017}],end:1661245643017},{name:"DSResponse serialization",start:1661245643017,end:1661245643017}],end:1661245643017},totalRows:9}]

From the above, I need to get only the projectcode and the respective projectId excluding all other data from the list.

In this example:

projectCode:"230822_1", projectId:149234

Can anyone help me to solve this?

CodePudding user response:

enter image description here

More information: enter image description here

  • Related