Skip to Main Content
Forums

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to do a replace of a string inside a group by

FofanaOct 26 2020

Hi All,
I have this code group by Account Name
<xsl:key name="groupByAccountName" match="invoice/accountInvoiceElements" use="accountName" />
Now the requirement, is this:
For example these Account Names
(Sponsor 1) Global Technology
(Sponsor 2) Global Technology
Global Technology
should be grouped together under Global Technology. In other words we need to remove the string (Sponsor 1) ...(Sponsor n) before the group by
I tried this but does not work
<xsl:key name="groupByAccountName" match="invoice/accountInvoiceElements" use="substring-after(accountName,'(Sponsor 1)'" />

Comments

Post Details

Added on Oct 26 2020
#xml, #xquery
0 comments
365 views