Q:

using sed to change numbers in a csv file

I have a csv file with 3 columns like below

Jones Smith 656220665 

I would like to convert it to

Jones Smith 000000000

The problem i have is not all the numbers are the same length. some are 7 digits long. i can't seem to find a way to change them from their current format to 0,s and has to use sed and cut 
Here is 2 of the codes i tried and tried to manipulate to suit my needs
sed 's/\([^ ]*\) \([^_]*\)_\(.*\)/\1 \3/g'   Input_file

and
$ sed 's/\(\([^,]\+,\)\{1\}\)\([^,]\+,\)\(.*\)/\1\3\3\4/' /path/to/your/file

A:

Instead of using sed, how about this:
echo 'Jones Smith 656220665' | tr '[0-9]' '0'
Jones Smith 000000000

For the whole file that's then:
tr '[0-9]' '0' < file > file.tmp

Edit 1:
added a sed solution:
sed 's/[0-9]/0/g' smith
Jones Smith 000000000

stil
Edit 2:
cat ClientData.csv > ClientData.csv.bak
sed 's/[0-9]/0/g; w ClientData.csv' ClientData.csv.bak | cut -d" " -f 1-2

