Query xml

2 years ago
25 November 2021
1 reply
4 views

+3

Kammasood
15 replies

HI, i have an xml output and would like to extract username out of it. can someone please help?

I would like to get Kamran out of the xml output.

[{"Editor":{"Name":"i:0#.f|membership|Kamran@gmail.com"}}]

please advise?

1 reply

+9

First of all that's JSON not XML. To extract the name use "Regular Expression" action with following parameters:

Pattern: ^.*|([^|]*)@.*$

Operation: Replace text

Replacement text: $1

Reply