hello all
i am having one requirnment,
for quality reasons we have to give a data from the data base to QA team for tesitng and quality mentainance in form of excel sheets.
is there any way i can change the data in the excel feils and then give to them and when they perform some test i can reconver them back.

for example
original data is
NAME1 ADDRESS1 TELEPHONE
TECH IDS D 122 999 999999


changed/mask data would be
NAME1 ADDRESS1 TELEPHONE
SDBGzHCR C,011 888,888888


c

There are many ways to do it . Since you mentioned Excel - You could select a PK , Create test data on a new sheet and maintain referential context using a VLOOKUP function. Hope this helps .

no thats not working for me
because its sheet with may such entries

where i am reaplacing all the
b -> a
2 - > 1

like that each character of some rows

I'm not clear what you are asking for. Are you starting with the data in a DB? If so, which one?
You could extract the data into a csv (comma separated value) format, which Excel will automatically be able to read.
For MySQL as the src, the fn you'd want is concat_ws() http://dev.mysql.com/doc/refman/5.0/...tion_concat-ws

Hello

check the the below mentioned comments it will help in understanding it.


original data in excel sheet
NAME1 ADDRESS1 TELEPHONE
TECH-IDS D 122 999 999999


changed/mask data would be
NAME1 ADDRESS1 TELEPHONE
SDBGzHCR C,011 888,888888


if you check the above example

T is replace with S
E with D
C with B
H with G
(blank space) with ,
I with H
D with C
S with R
9 with 8
8 with 7

like that was
hope i am able to explain it fully now :-)

hi
how to do the greb aditing in linux to windows xp & vista & windows 7

Here are some options.

1. excel will limit your data - Since your requirement is small , you could do a Find Replace for each LETTER . Here are some limitations .
Your data will have limitations with the case .
You will not be able to change numbers.

You could change all characters to UPPER .
<>F AND <>R Characters to the de-identified letter , making it case sensitive.

Once testing is complete - You can reverse the values.

2. You can also write a function to replace values from a reference table by hashing the first say 20 bytes - and reverse the values based on the hash value.



3. Concat Name 1 and Address 1 to make it the PK ( hoping it is unique ), or Identify a PK.

Create a test address able -
Like 1 Test Street , Apt 100 | Test City | Test State | Test Zip.
Replace using VLOOKUP function based on PK.

Once testing is complete , you can reverse the values using the PK originally created .

if its difficult for excel then can i do this in mysql or access ?
i will upload the data from excle to mysql or access

is there any data masking tools for mysql ?

Open a new thread for a new question, don't tack them onto old threads.

ok sir no issues :-)