hi guys i have 6000 rows column
the text in the column has the symbol vertical bar |.
i tried some of the commands to remove it but none of the commands are reconzng this symbol. would u plz help to remove this symbol from the text with any kind of unix command
u r help would be appreciated
girish
Try this:
echo "a|b|c" | sed 's/\|//g'
or
echo "a|b|c" | tr -d "|"
Thanx alot for the reply.but the command is nt working
the file will be like this .these boxes appearing as | symbol in the text file. I just need numbers in the same style.
2933263
115194950
114942489
114942929
133258873
86812767
116188061
173556370
82609498
100487454
87852218
9892869
117204744
44033204
2279866
29726304
158331086
95228718
You can try this..
awk -F "|" '{print $1}' filename
I'm getting result like the same.......... sorry!
I'm getting the input as output no change at all
You can try this:
awk '{print substr($0,1, match($0,"[^0-9]")-1)}' file
Regards
Digby
January 30, 2009, 6:31am
8
All of the following work for me. I think some of them have been suggested before.
perl -pe 's/\|//' < file
sed 's/|//g' < file
awk -F\| '{print $1}' < file
Thanx alot Franky
It's working like Mariijuana:b: