How can we help you today? How can we help you today?

Masking nested XML attributes

Hello,

Hoping someone can help, please. I'm trying to mask an XML attribute but not having much luck setting up the rule. My data looks like this:

 

<clientlifestyles>

<clientlifestyle unit="0" name="NoLifestyle" cont_id="424583" cont_set_id="0" isassumed="false" value="" containsassumeddata="false" />

<clientlifestyle unit="21" name="ClientName" cont_id="0" cont_set_id="1" isassumed="false" value="Example Name" containsassumeddata="false" />

<clientlifestyle unit="24" name="ClientDOB" cont_id="0" cont_set_id="2" isassumed="false" value="16/09/1987" containsassumeddata="false" />

<clientlifestyle unit="25" name="ClientGender" cont_id="0" cont_set_id="3" isassumed="false" value="Male" containsassumeddata="false" />

<clientlifestyle unit="26" name="OccupationId" cont_id="0" cont_set_id="7" isassumed="false" value="purchasing manager" containsassumeddata="false" />

<clientlifestyle unit="23" name="PostCode" cont_id="0" cont_set_id="9" isassumed="false" value="BN20 8XS" containsassumeddata="false" />

<clientlifestyle unit="0" name="ClientTitleOther" cont_id="0" cont_set_id="2739" isassumed="false" value="" containsassumeddata="false" />

...and I'm trying to mask the "Example Name" attribute.Would someone please be able to help with the XPath to target that attribute, please?

Many thanks,

Frank

Frank Doyle
0

Comments

4 comments

  • Tianjiao_Li
    Hi Frank,

    Have you had a look of this documentation? https://documentation.red-gate.com/dms6/data-masker-help/masking-rules/about-xml-masker-rules

    If you still require further assistant, can you attach your masking set?
    Tianjiao_Li
    0
  • FPD

    Hi Tianjiao Li,

    Thanks for your reply - I did read the documentation and after some trial and error was able to work it out.

    I had to work out the XPath specification - but once that was done it worked perfectly.

    If anyone else is reading this and having similar issues, I found the following website particularly useful for working out the XPath to traverse my XML:

    https://www.freeformatter.com/xpath-tester.html

    Kind regards,


    Frank Doyle


    FPD
    0
  • FPD

     Hi Tianjiao Li,

    Thanks for your reply - I did read the documentation and after some trial and error was able to work it out.

    I had to work out the XPath specification - but once that was done it worked perfectly.

    If anyone else is reading this and having similar issues, I found the following website particularly useful for working out the XPath to traverse my XML:

    https://www.freeformatter.com/xpath-tester.html

    Kind regards,
    Frank


    FPD
    0
  • Tianjiao_Li
    @FPD

    It's great to hear you've worked it out and thanks for sharing the useful link!
    Tianjiao_Li
    0

Add comment

Please sign in to leave a comment.