Originally posted by: paul.brett

Here's a pair of maps that can be use to sanitise data if it contains sensitive information, prior to sending it to IBM technical support for review as part of a testcase (assuming of course that the issue being reported can be replicated with the sanitised data).

Input data:   (both ASCII and EBCDIC versions)

This is a secret message with an account number (0123456789) and some other secret stuff.
This is a secret message with an account number (0123456789) and some other secret stuff.
This is a secret message with an account number (0123456789) and some other secret stuff.

Output data:   (both ASCII and EBCDIC versions)

Aaaa aa a aaaaaa aaaaaaa aaaa aa aaaaaaa aaaaaa (0000000000) aaa aaaa aaaaa aaaaaa aaaaa.
Aaaa aa a aaaaaa aaaaaaa aaaa aa aaaaaaa aaaaaa (0000000000) aaa aaaa aaaaa aaaaaa aaaaa.
Aaaa aa a aaaaaa aaaaaaa aaaa aa aaaaaaa aaaaaa (0000000000) aaa aaaa aaaaa aaaaaa aaaaa.

Thank you.

Paul.

Follow me on Twitter

Originally posted by: paul.brett

Here's a copy of my 'SplitDataAndTags' map that has been slightly altered to call my 'SanitiseAscii' map, so that XML data can be sanitised:

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <Address>
    <AddrLine1>123 Arcadia Avenue</AddrLine1>
    <AddrLine2>Little Whinging</AddrLine2>
    <PostTown>READING</PostTown>
    <County>Berkshire</County>
    <PostCode>RE12 3DG</PostCode>
  </Address>
  <Address>
      <AddrLine1>Flat 7</AddrLine1>
      <AddrLine2>Bellvue Court</AddrLine2>
      <PostTown>CHELMSFORD</PostTown>
      <County>Essex</County>
      <PostCode>CM6 9TW</PostCode>
  </Address>
</root>

to

<?xml version="1.0" encoding="UTF-8"?>
<root>
  <Address>
    <AddrLine1>000 Aaaaaaa Aaaaaa</AddrLine1>
    <AddrLine2>Aaaaaa Aaaaaaaa</AddrLine2>
    <PostTown>AAAAAAA</PostTown>
    <County>Aaaaaaaaa</County>
    <PostCode>AA00 0AA</PostCode>
  </Address>
  <Address>
      <AddrLine1>Aaaa 0</AddrLine1>
      <AddrLine2>Aaaaaaa Aaaaa</AddrLine2>
      <PostTown>AAAAAAAAAA</PostTown>
      <County>Aaaaa</County>
      <PostCode>AA0 0AA</PostCode>
  </Address>
</root>

Any input data where the structure needs to remain unchanged would need to be treated in this way.

Thank you.

Paul.

Follow me on Twitter

Attachment(s)

SanitiseXML.zip   4 KB 1 version

Originally posted by: DeM0n

That's great...I had wasted many hours removing PHI from the EDI files...this is amazing...Thanks Paul...

Could you please explain how the SanitiseAscii.txt and SanitiseEbcdic.txt are created.

Originally posted by: paul.brett

I used a byte editor.  I create a file of 256 bytes in length, each byte is sequentially higher than the previous byte, starting from hex 00.

All the numbers from hex 30 to 39 were replaced with hex 30.

All the uppercase letters starting with 'A' at hex 41 to hex 5A inclusive were replaced with hex 41.

All the lowercase letters starting with 'a' at hex 61 to hex 7A inclusive were replaced with hex 61.

I used the same technique for the EBCDIC file.

Thank you.

Paul.

Follow me on Twitter

Originally posted by: DeM0n

Thanks Paul....I got it....

Thanks again !!!