rexx code



IBM's Command List programming language & Restructured Extended Executor

rexx code

Postby mainframe1 » Thu Jan 29, 2009 4:33 pm

i have file, want to mask the adress lines and telephone numbers
but the space ansd special chararters need to be retained. the adres and telephone will changing dynamicallya file changes.
pls help how to code using rexx
mainframe1
 
Posts: 35
Joined: Wed Oct 08, 2008 11:39 am
Has thanked: 0 time
Been thanked: 0 time

Re: rexx code

Postby expat » Thu Jan 29, 2009 5:12 pm

I think that you need to explain exactly what you wish to achieve. Masking does not really say too much.

Also give an example of what you start with, and what you want to end up with. This usually helps people see what you want more clearly.

Is this for "scrubbing" production data for a test environment ? If so, REXX is not the greatest tool for large volume datasets, so maybe consider another tool to achieve this.
expat
 
Posts: 459
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 8 times

Re: rexx code

Postby mainframe1 » Thu Jan 29, 2009 5:27 pm

yes, this is for scrubbing" production data for a test environment , to get the adress and allthet stuff masked or in another format

say the name is katherie mathew, it had to be asfvcfg bhyuijk or
xxxxxxx xxxxxxx, the spaces and special cgaradter has to be retained.

the jumbled one must sbot repeat,a some other name come, sau johny-andrews
it has be asdff-errttyu

pls help
mainframe1
 
Posts: 35
Joined: Wed Oct 08, 2008 11:39 am
Has thanked: 0 time
Been thanked: 0 time

Re: rexx code

Postby dick scherrer » Fri Jan 30, 2009 1:10 am

Hello,

Suggest you consider a different way to "hide" the names. REXX will not be your friend for this requirement - especially if there is a high volume of data.

Also suggest you pick a subset of the "real" names to test with and create a table that shows what test name should be substituted for each real name. If you insist on generating the fake name in code, i'd suggest a callable (cobol?) module that you pass the real name to and the routine generates the fake name. You might consider a vsam file or database table to contain both names so you can ensure uniqueness as well as know which fake name goes with which real name if that need arises during testing. This cross-reference info would not be made available to just everyone.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post