Search code examples
regexxmlc#-4.0rdl

Append value of an XML Element with additional text using regular expressions

I am trying to convert the following in an XML

<SharedDataSetReference>AnyDataSetName</SharedDataSetReference>

to

<SharedDataSetReference>/DataSets/AnyDataSetName</SharedDataSetReference>

at the same time, existing instances of 

<SharedDataSetReference>/DataSets/AnyDataSetName</SharedDataSetReference>

should remain unchanged.

Pls note that AnyDataSetName can have 

<SharedDataSetReference>Company</SharedDataSetReference>
<SharedDataSetReference>Customer</SharedDataSetReference>

or /Datasets/Order

and they should change to 

<SharedDataSetReference>/Datasets/Company</SharedDataSetReference>
<SharedDataSetReference>/Datasets/Customer</SharedDataSetReference>
<SharedDataSetReference>/Datasets/Order</SharedDataSetReference>
Solution

  • Try this

    <SharedDataSetReference>([^\/]+)<\/SharedDataSetReference>

    https://regex101.com/r/yM7tA0/1