grep '\~' b | awk '{print $1","$3}' | sed -e 's/~//g'

Shell Programming and Scripting
1

Hi all,

   
grep '\~' b | awk '{print $1","$3}' | sed -e 's/~//g'

Iam using above command for some report...

can this be done using any one of them either sed or awk or grep...

2

Try:

awk '/~/ {$1=sub(/~/,"",$1); $3=sub(/~/,"",$3); print $1","$3}' b
3

$ nawk '/~/ {$1=sub(/~/,"",$1); $3=sub(/~/,"",$3); print $1","$3}' b
1,0
1,0
1,0
1,0
1,0
1,0
1,0
1,0
1,0
1,0
1,0

Iam getting above output

4

Sorry did not get your req correct...
Try:

awk '/~/ {gsub(/~/,"",$1); gsub(/~/,"",$3); print $1","$3}' b