Match and replace condition in Excel Template
Summary
Match and replace condition in Excel TemplateContent
Hi Team,
I am working on an Excel template for report output.
I have the data in XML below:
<?xml version = '1.0' encoding = 'utf-8'?>
<!--Generated by Oracle BI Publisher -Dataengine, datamodel:__Gaurav_Gupta_TEST_DM_xdm -->
<DATA_DS>
<G_1>
<USERNAME>10000074</USERNAME><FIRST_NAME>Kerri</FIRST_NAME><LAST_NAME>Harris</LAST_NAME><PERSON_NUMBER>10000074</PERSON_NUMBER><LAST_UPDATED_BY>REQUESTS</LAST_UPDATED_BY><LAST_UPDATE_DATE>23-02-2020</LAST_UPDATE_DATE><ROLENAME>MTA - Line Manager Data Role; MTA-BN12-ADMINISTRATOR-ALL; MTA-BN12-MANAGER-ALL; MTA-BN12-SPECIALIST-ALL; MTA-HR12-ANALYST-ALL; MTA-HR12-MANAGER-ALL; MTA-HR12-SPECIALIST-ALL; MTA-PR12-MANAGER-ALL; Application Administrator</ROLENAME>
Tagged:
0