Converting data from specific columns

i have a file (csv or txt or anything which has 4 columns (id,name,number,location) and it contains data. i want to convert the data of specific columns like name to ooooo and number to 88888 matching the field length of that columns.
for example
if name column has
anthony which is 7, it should be converted to ooooooo and same for number and it should create an output file with same name or may be different.

Show the input you have and show the output you want, in code tags,

```text
stuff
```

Would fields consist of numbers AND alpha chars, like anthony3 ? What to do in this case?