Query xml | Community

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?

Page 1 / 1

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

Sign up