List of Contributions

Harshavardhan Peddireddy

Contact Details

My Content

1 to 7 of 7 total
Posted By Harshavardhan Peddireddy Apr 1, 2020 9:25 AM
Found In Egroup: Optim
\ view thread
​Hi Hari Try trim function str1 = optim.source.getcolumnvalue() str = str1:gsub(""%s+"", "" "") if (str ~= nil) then Your Lookup script ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Mar 31, 2020 4:32 PM
Found In Egroup: Optim
\ view thread
Hi Trong To pick a specific part of string and mask, you no need to write LUA. You can use Affinity as is. Try below example : -- TRANS PRO=aff, algo=fpe, mtd=rep, key="xyzabcxyz", COPY=(1,4), COPY=(5,2), iterations=12, tweaks=no, flddef1=(name="Source field name", dt=varchar)​ ------------------------------ ...
Posted By Harshavardhan Peddireddy Mar 31, 2020 4:16 PM
Found In Egroup: Optim
\ view thread
Hi Hari Try below lines under Source section ( specially line 3, 4 , 5) pro=hash_lookup, hashfld="seq", source="Source Column name", PRESERVENULL ="Source Column name", PRESERVESPACES ="Source Column name", PRESERVEZEROLENGTH ="Source Column name", rep="lookup table field",​ ------------------------------ ...
Posted By Harshavardhan Peddireddy Feb 18, 2020 10:10 AM
Found In Egroup: B2B Integration
\ view thread
​Hi Vivek, Thanks for your kind reply. As long as it masks all the sensitive fields ( Name, Address, SSN, Phone, Health care records ) I am good to use short paths. Please advise. Thank you ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Feb 17, 2020 9:53 AM
Found In Egroup: B2B Integration
\ view thread
Hi Team, Any advise to my question ?​ ------------------------------ Harshavardhan Peddireddy ------------------------------
Posted By Harshavardhan Peddireddy Feb 13, 2020 11:11 AM
Found In Egroup: B2B Integration
\ view thread
Hi All,​ We got a request to Mask data in the EDI (834,835 & 837) files and the Data Masking Tool that we use doesn't support EDI files directly. We need to Covert EDI files into CSV/Flat files and input those files as source to Data Masking Tool and Mask the data. Post masking, we need to use ...
Posted By Harshavardhan Peddireddy Feb 13, 2020 11:11 AM
Found In Egroup: B2B Integration
\ view thread
​Hi Team, We got a request to Mask data in the EDI (834,835 & 837) files and the Data Masking Tool that we use doesn't support EDI files directly. We need to Covert EDI files into CSV/Flat files and input those files as source to Data Masking Tool and Mask the data. Post masking, we need to ...