Isaac
Lifelong Learner
- Local time
- Today, 13:00
- Joined
- Mar 14, 2017
- Messages
- 8,784
I'm actually doing this in Excel but posting it in Access for traffic's sake, and because the actual thrust of my question has nothing to do with whether it is done in Access or Excel, it's just asking for ideas.
I've written a macro (think 'query' if you want) that changes data for the purpose of de-sensitizing it. You can pick a workbook, worksheet and column and the it runs through and changes every vowel to "x". That's just a start for proof of concept.
What I'm wondering now is how to make it more effective. If my manager sees that I have (obviously) changed "Johnson" to "Jxhnsxn", that might not be good enough.
I'm thinking of coming up with something a little bit more random, and that covers consonants as well, but it needs to be predictable enough so that data de-sensitized in one datasource - which is supposed to match another data source - still matches that other datasource.
I guess what I'm wondering is, given this situation I've already come up with, do you have any ideas merely as to the logic of how I might approach it?
I suppose if I just chose a specific replacement vowel for each vowel, and then one for each consonants (or at least most consonants), that may fit the bill - any other ideas?
I've written a macro (think 'query' if you want) that changes data for the purpose of de-sensitizing it. You can pick a workbook, worksheet and column and the it runs through and changes every vowel to "x". That's just a start for proof of concept.
What I'm wondering now is how to make it more effective. If my manager sees that I have (obviously) changed "Johnson" to "Jxhnsxn", that might not be good enough.
I'm thinking of coming up with something a little bit more random, and that covers consonants as well, but it needs to be predictable enough so that data de-sensitized in one datasource - which is supposed to match another data source - still matches that other datasource.
I guess what I'm wondering is, given this situation I've already come up with, do you have any ideas merely as to the logic of how I might approach it?
I suppose if I just chose a specific replacement vowel for each vowel, and then one for each consonants (or at least most consonants), that may fit the bill - any other ideas?