Hello,
I'm trying to do some RegExp in preprocessing:
Trying this RegExp - \[?(({"{#SNMPINDEX}":"([0-9]){0,3}((\.0)|(\.[1-9][0-9]*)){2}","{#ZONA}":".{1,20}"}),)
to apply on this string:
[{"{#SNMPINDEX}":"1.1.0","{#ZONA}":"Cold A9A10"},{"{#SNMPINDEX}":"1.2.1.0","{#ZONA}":"280"} ,{"{#SNMPINDEX}":"1.2.2.0","{#ZONA}":"50"},{"{#S NM PINDEX}":"1.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}": "1.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"1.3. 2.0" ,"{#ZONA}":"0"},{"{#SNMPINDEX}":"1.3.3.0","{#ZO NA} ":"0"},{"{#SNMPINDEX}":"2.1.0","{#ZONA}":"Hot A7A8"},{"{#SNMPINDEX}":"2.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"2.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"2.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 2.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"2.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"2.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"3.1.0","{#ZONA}":"Hot A4A5"},{"{#SNMPINDEX}":"3.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"3.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"3.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 3.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"3.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"3.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"4.1.0","{#ZONA}":"Cold A6A7"},{"{#SNMPINDEX}":"4.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"4.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"4.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 4.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"4.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"4.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"5.1.0","{#ZONA}":"Cold A1A2"},{"{#SNMPINDEX}":"5.2.1.0","{#ZONA}":"265"}, {"{#SNMPINDEX}":"5.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"5.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 5.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"5.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"5.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"6.1.0","{#ZONA}":"Cold A4A5"},{"{#SNMPINDEX}":"6.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"6.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"6.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 6.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"6.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"6.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"7.1.0","{#ZONA}":"Sensor 7"} ,{"{#SNMPINDEX}":"7.2.1.0","{#ZONA}":"250"},{"{# SN MPINDEX}":"7.2.2.0","{#ZONA}":"50"},{"{#SNMPINDEX} ":"7.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"7. 3.1. 0","{#ZONA}":"0"},{"{#SNMPINDEX}":"7.3.2.0","{# ZON A}":"0"},{"{#SNMPINDEX}":"7.3.3.0","{#ZONA}":"0" }, {"{#SNMPINDEX}":"8.1.0","{#ZONA}":"Sensor8"},{" {#S NMPINDEX}":"8.2.1.0","{#ZONA}":"250"},{"{#SNMPINDE X}":"8.2.2.0","{#ZONA}":"50"},{"{#SNMPINDEX}":"8 .2 .3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"8.3.1.0","{# ZONA}":"0"},{"{#SNMPINDEX}":"8.3.2.0","{#ZONA}":"0 "},{"{#SNMPINDEX}":"8.3.3.0","{#ZONA}":"0"}]
When I test it in regex101.com (https://regex101.com/r/90sfft/1) it works fine that is match only text that I need to match:
[{"{#SNMPINDEX}":"1.1.0","{#ZONA}":"Cold A9A10"},
{"{#SNMPINDEX}":"2.1.0","{#ZONA}":"Hot A7A8"},
{"{#SNMPINDEX}":"3.1.0","{#ZONA}":"Hot A4A5"},
{"{#SNMPINDEX}":"4.1.0","{#ZONA}":"Cold A6A7"},
{"{#SNMPINDEX}":"5.1.0","{#ZONA}":"Cold A1A2"},
{"{#SNMPINDEX}":"6.1.0","{#ZONA}":"Cold A4A5"},
{"{#SNMPINDEX}":"7.1.0","{#ZONA}":"Sensor7"},
{#SNMPINDEX}":"8.1.0","{#ZONA}":"Sensor8"},
but, when I try to do that in preprocessing:

with parameters:
pattern=\[?(({"{#SNMPINDEX}":"([0-9]){0,3}((\.0)|(\.[1-9][0-9]*)){2}","{#ZONA}":".{1,20}"}),)
output=\0
I get only first match:
"[{"{#SNMPINDEX}":"1.1.0","{#ZONA}":"Cold A9A10"},"
i.e.:

Can someone help me with this?
I'm trying to do some RegExp in preprocessing:
Trying this RegExp - \[?(({"{#SNMPINDEX}":"([0-9]){0,3}((\.0)|(\.[1-9][0-9]*)){2}","{#ZONA}":".{1,20}"}),)
to apply on this string:
[{"{#SNMPINDEX}":"1.1.0","{#ZONA}":"Cold A9A10"},{"{#SNMPINDEX}":"1.2.1.0","{#ZONA}":"280"} ,{"{#SNMPINDEX}":"1.2.2.0","{#ZONA}":"50"},{"{#S NM PINDEX}":"1.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}": "1.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"1.3. 2.0" ,"{#ZONA}":"0"},{"{#SNMPINDEX}":"1.3.3.0","{#ZO NA} ":"0"},{"{#SNMPINDEX}":"2.1.0","{#ZONA}":"Hot A7A8"},{"{#SNMPINDEX}":"2.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"2.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"2.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 2.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"2.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"2.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"3.1.0","{#ZONA}":"Hot A4A5"},{"{#SNMPINDEX}":"3.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"3.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"3.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 3.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"3.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"3.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"4.1.0","{#ZONA}":"Cold A6A7"},{"{#SNMPINDEX}":"4.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"4.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"4.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 4.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"4.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"4.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"5.1.0","{#ZONA}":"Cold A1A2"},{"{#SNMPINDEX}":"5.2.1.0","{#ZONA}":"265"}, {"{#SNMPINDEX}":"5.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"5.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 5.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"5.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"5.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"6.1.0","{#ZONA}":"Cold A4A5"},{"{#SNMPINDEX}":"6.2.1.0","{#ZONA}":"250"}, {"{#SNMPINDEX}":"6.2.2.0","{#ZONA}":"50"},{"{#S NMP INDEX}":"6.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":" 6.3.1.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"6.3.2.0", "{#ZONA}":"0"},{"{#SNMPINDEX}":"6.3.3.0","{#ZO NA}" :"0"},{"{#SNMPINDEX}":"7.1.0","{#ZONA}":"Sensor 7"} ,{"{#SNMPINDEX}":"7.2.1.0","{#ZONA}":"250"},{"{# SN MPINDEX}":"7.2.2.0","{#ZONA}":"50"},{"{#SNMPINDEX} ":"7.2.3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"7. 3.1. 0","{#ZONA}":"0"},{"{#SNMPINDEX}":"7.3.2.0","{# ZON A}":"0"},{"{#SNMPINDEX}":"7.3.3.0","{#ZONA}":"0" }, {"{#SNMPINDEX}":"8.1.0","{#ZONA}":"Sensor8"},{" {#S NMPINDEX}":"8.2.1.0","{#ZONA}":"250"},{"{#SNMPINDE X}":"8.2.2.0","{#ZONA}":"50"},{"{#SNMPINDEX}":"8 .2 .3.0","{#ZONA}":"0"},{"{#SNMPINDEX}":"8.3.1.0","{# ZONA}":"0"},{"{#SNMPINDEX}":"8.3.2.0","{#ZONA}":"0 "},{"{#SNMPINDEX}":"8.3.3.0","{#ZONA}":"0"}]
When I test it in regex101.com (https://regex101.com/r/90sfft/1) it works fine that is match only text that I need to match:
[{"{#SNMPINDEX}":"1.1.0","{#ZONA}":"Cold A9A10"},
{"{#SNMPINDEX}":"2.1.0","{#ZONA}":"Hot A7A8"},
{"{#SNMPINDEX}":"3.1.0","{#ZONA}":"Hot A4A5"},
{"{#SNMPINDEX}":"4.1.0","{#ZONA}":"Cold A6A7"},
{"{#SNMPINDEX}":"5.1.0","{#ZONA}":"Cold A1A2"},
{"{#SNMPINDEX}":"6.1.0","{#ZONA}":"Cold A4A5"},
{"{#SNMPINDEX}":"7.1.0","{#ZONA}":"Sensor7"},
{#SNMPINDEX}":"8.1.0","{#ZONA}":"Sensor8"},
but, when I try to do that in preprocessing:
with parameters:
pattern=\[?(({"{#SNMPINDEX}":"([0-9]){0,3}((\.0)|(\.[1-9][0-9]*)){2}","{#ZONA}":".{1,20}"}),)
output=\0
I get only first match:
"[{"{#SNMPINDEX}":"1.1.0","{#ZONA}":"Cold A9A10"},"
i.e.:
Can someone help me with this?
Comment