AnsweredAssumed Answered

How to find and replace (manipulate) in XML

Question asked by nintex2020 on Jun 1, 2017
Latest reply on Jun 1, 2017 by emha

I have the following xml from repeat table of form. I need to replace user ID (for example PROCTORE\tlamfuki with this user's display name "Tommy Lamfukilami") in an XML with that user's display name. Any suggesion? 

 

<?xml version="1.0" encoding="utf-8"?><RepeaterData><Version /><Items><Item><Discipline type="System.String">Evaluation</Discipline><DisciplineApprover type="System.String">PROCTORE\tlamfuki</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Initial Design</Discipline><DisciplineApprover type="System.String">PROCTORE\cschwab</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Changed Design</Discipline><DisciplineApprover type="System.String">PROCTORE\msteel</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Proposed Design</Discipline><DisciplineApprover type="System.String">PROCTORE\tlamfuki</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Production Design</Discipline><DisciplineApprover type="System.String">PROCTORE\cschwab</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Quality Group</Discipline><DisciplineApprover type="System.String">PROCTORE\msteel</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Quality Management</Discipline><DisciplineApprover type="System.String">PROCTORE\cschwab</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item><Item><Discipline type="System.String">Final Management</Discipline><DisciplineApprover type="System.String">PROCTORE\msteel</DisciplineApprover><StatusOfWork type="System.String"></StatusOfWork><DateOfApproval type="System.DateTime"></DateOfApproval></Item></Items></RepeaterData>

Outcomes