CA TPX Session Management for z/OS

Expand all | Collapse all

Mask CSV file query

  • 1.  Mask CSV file query

    Posted 03-22-2018 12:32 PM

    I have a flat file with column having value as 'ABC123456' and ELD123456'

     

    I want to create transformation map for that file.(mainframe flat file)

     

    I`m looking like function is to mask only(only numeric with first 3 digit char as 'ABC' not others.

     

    the results would be

    'ABC786232' and ELD123456'



  • 2.  Re: Mask CSV file query

    Posted 03-22-2018 01:41 PM

    Hi,

    It is not clear if this question is for CA Disk or CA Allocate.  But, the basic fact is this...

    I would presume that the numeric portion of the values you are looking for would be far greater than the "ABC" and "ELD" portion of the values.  If that is the case, then masking for  "ABC" and "ELD" would make sense.

    If you can provide more info, maybe a better answer can be provided.

    Don Bell
    CA Technologies
    Principal Support Engineer



  • 3.  Re: Mask CSV file query

    Posted 03-22-2018 04:04 PM

    Hi,

    Consider this scenario.

     

    I have a flat file. one field having with value as 'ABC12345', 'BVC23456' and 'GHT56789' etc.

    My expectation is to mask only numeric values, so i apply partmask function.

    the result would be 'ABC12334', 'BVC23232' and 'GHT34334'

     

    But i want to do mask like. if first 3 position of column value equal to 'ABC' then mask numeric value else leave as it is.

     

    Expectation result would be 'ABC12334', BVC23456' and 'GHT56789' etc. mask only those columns with having first 3 chars as 'ABC'.

     

    Unable to use where and like condition here. its taking whole column not like first 3 chars.

     

    its mainframe flat file for do masking.

     

    Please advise.



  • 4.  Re: Mask CSV file query

    Posted 03-22-2018 04:30 PM

    Hi,

     

     

     

    You refer to, "partmask function".

     

    This is not a function of either CA Allocate or CA Disk.

     

    You need to direct your question to the proper product.

     

    Sorry that I can not help you.

     

     

     

    Don

     

     

     

    Donald Bell

     

    Principal Support Engineer, Global Customer Success

     

    One team, Your success, Every day

     

    CA Technologies | 5465 Legacy Drive Suite 700 | Plano, TX  75024-3106

     

    Office:  775-622-1969[cid:b317f3c0-50fc-46b5-b81c-8b6379c5acd6] | beldo05@ca.com<mailto:beldo05@ca.com>



  • 5.  Re: Mask CSV file query

    Posted 03-22-2018 05:57 PM

    I can’t tell if you are looking for something you can use within an edit session, or from a REXX tool or similar. If so, you can just use the change command with regular expressions. For your example, it would be:

     

    CHANGE R’ABC[0-9][0-9][0-9][0-9][0-9]’ ‘ABC22334’ ALL to change everything that starts with ABC and has 5 digits, to be ABC22334.

     

    If you’re looking for this function within a particular tool, please give us more information to help in your situation.

     

    Don Friedel Jr.

    Office: 214-473-1217 | Mobile: 512-585-8152

    Donald.FriedelJr@ca.com<mailto:Donald.FriedelJr@ca.com>

    CA Technologies | 5465 Legacy Drive Suite 700 | Plano, TX 75024-3106

     

    Registration Link: https://communities.ca.com/events/4223-cadreca-datacom-technical-conference-30-april-2018

    Join the conversation on Twitter with @CAinc #Datacom #CADRE18