Kammasood
Scholar

Query xml

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?

0 Kudos
Reply
1 Reply
mlauer
Collaborator

Re: Query xml

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

 

 

0 Kudos
Reply