This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I was looking for a SHA256 encryption tool and couldn't find one (2022-08-02), so with the help of @grossal we used python (sparingly) and created this macro. While useful for encryption of email addresses, it can be used on any string data. The macro will give you CONVERSION warnings if you have EMPTY data and will enforce lowercase on you. If you don't like these features, you can turn them off.
Incoming data is routed (top) to a JOIN tool and the SHA256_INPUT & RecordID are SELECTED to process through the macro. Warnings and lowercase conversion of data are optionally processed on just the minimum data columns for efficiency. A filter tool prevents empty data from being encrypted (Python will fail on empty data). The data is brought back together and appended (as the last field) to the original data. CReW tests (Expect 0) are performed to FAIL if any un-Joined data exists (I think that is impossible, but good practice here) an ERROR will occur. The output then is returned to you.
When you need to use Python, use it. This macro uses python to achieve the goal of SHA256 encryption of a single text field. For those who know me, please don't think that anyplace has frozen over or that the end of the world is near just because I wrote a macro using python.