I have XML in the format present below and i am trying to use field transformation and field extraction in order to extract the field in people format.
Could you please help me in creating regular expression for this xml
<ns4:includeme>false</ns4:includeme> <m:houseref>21</m:houseref> <m1:security>***</m1:security> <Name>Argus</Name>
I would like to have a single regular expression which i can use to extract all the field values and field name.
I tried to use below
But its not capturing the last one Argus
So i would like to know if it can be possible if yes then what would be the expression.
Your regex string was very close. The colon is optional so I put a question mark after it in the regex. This worked for me on regex101.com with your sample data.
Thanks for coming back to me.
Then it is only capturing me part from Name and i want full Name to be rexed out.
I am not sure how to use spath.
If you help me in understanding the syntax and usage it would be helpfull.
Try this and then figure out what is what is wonky in your search (by default it works from the
| makeresults | eval _raw="<ns4:includeme>false</ns4:includeme> <m:houseref>21</m:houseref> <m1:security>***</m1:security> <Name>Argus</Name>" | spath