UNIX for Advanced & Expert Users

Hi,

I have a file A.txt (tab separated) as below:

pavan chennai/tes/bangalore 100
sunil mangalore/abc/mumbai 230
kumar delhi/nba/andhra 310


I want to change only second column as below . Rest of columns as it is ;The ouput file is also tab separated.

pavan chennai/###/bangalore 100
sunil angalore/###/mumbai 230
kumar delhi/###/andhra 310

Please let me know how to do this in unix script. I am using ksh shell
Thanks in advance

If you have something like pavan tab chennai/tes/bangalore tab 100, then:

Code:

echo -e "pavan\tchennai/tes/bangalore\t100"|perl -ne 'print if (s/^(.*?\t.*?\/).*?(\/.*?\t.*?)$/$1###$2/g);'
or cat file_with_those_lines | perl -ne 'print if (s/^(.*?\t.*?\/).*?(\/.*?\t.*?)$/$1###$2/g);'

Thanks .....

It is working but present working directory path is appending at the end of last line in the file .


pavan chennai/tes/bangalore 100
sunil mangalore/abc/mumbai 230
kumar delhi/nba/andhra 310[servername] /path/


Please suggest me .

Alos if there are many columns in a files is there a way give range like $2- $100 .

With sed:

Code:

sed 's_\(.*/\).*\(/.*\)_\1###\2_' file > newfile

Regards

if you have PHP

Code:

<?php
$file = "file";
$data=file($file);
foreach($data as $k=>$v){
  $v=explode("/",$v);
  $v[1]="###";
  $v=implode("/",$v);
  echo "$v";
}
?>