Skip to main content
Nintex Community Menu Bar

Query xml

  • November 25, 2021
  • 1 reply
  • 9 views
K
Forum|alt.badge.img+3

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

    M
    Forum|alt.badge.img+9
    • mlauer
    • November 25, 2021

    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

     

     

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement