Want to mask all the rows in a column at once?

Thread view:

RG007 - 17 Jan 2006 04:42 GMT

I want to mask all the data in the rows of a column using a character
i want suppose "x" for all the characters and "9'" for all the numbers
if the rows contain digits.
Right now I am having a code which goes to every character and checks
whether it is a number or alphabet and change to the required one.
But I want the code to be able to change the string at once to xxxxxxx
or 999999?
How to modify?

Reply to this Message

Roedy Green - 17 Jan 2006 05:41 GMT

>Right now I am having a code which goes to every character and checks
>whether it is a number or alphabet and change to the required one.
>But I want the code to be able to change the string at once to xxxxxxx
>or 999999?
>How to modify?

You will need a char by char loop. If you found a method, that is what
it woud do inside.

Signature

Canadian Mind Products, Roedy Green.
http://mindprod.com Java custom programming, consulting and coaching.

Reply to this Message

Venky - 17 Jan 2006 08:43 GMT

If data is in the database, then you can do that in a single SQL
statement (or a single JDBC call). Otherwise I can't think of any such
java function which can modify all the rows at once.

Reply to this Message

Want to mask all the rows in a column at once?

Free Magazines