Substitute numbers in a random IP address port with space

Clash Royale CLAN TAG#URR8PPP
up vote
1
down vote
favorite
I have a file with IP and port numbers. I would like to take out the port number and leave the IP alone.
xyz 10.93.10.13:58160).
xyz 10.93.10.13:58161).
xyz 10.18.104.181:12466).
xyz 10.93.10.13:60585).
wxy 10.93.10.13:60586).
wxy 10.93.10.13:60587).
ADMIN loopback[127.0.0.1]:33955).
ADMIN loopback[127.0.0.1]:33957).
ADMIN loopback[127.0.0.1]:33961).
ADMIN loopback[127.0.0.1]:33962).
expected output
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
i tried a lame procedure which won't work
cat 1.txt|grep -v [:12312]
thanks
text-processing ip-address
add a comment |Â
up vote
1
down vote
favorite
I have a file with IP and port numbers. I would like to take out the port number and leave the IP alone.
xyz 10.93.10.13:58160).
xyz 10.93.10.13:58161).
xyz 10.18.104.181:12466).
xyz 10.93.10.13:60585).
wxy 10.93.10.13:60586).
wxy 10.93.10.13:60587).
ADMIN loopback[127.0.0.1]:33955).
ADMIN loopback[127.0.0.1]:33957).
ADMIN loopback[127.0.0.1]:33961).
ADMIN loopback[127.0.0.1]:33962).
expected output
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
i tried a lame procedure which won't work
cat 1.txt|grep -v [:12312]
thanks
text-processing ip-address
add a comment |Â
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have a file with IP and port numbers. I would like to take out the port number and leave the IP alone.
xyz 10.93.10.13:58160).
xyz 10.93.10.13:58161).
xyz 10.18.104.181:12466).
xyz 10.93.10.13:60585).
wxy 10.93.10.13:60586).
wxy 10.93.10.13:60587).
ADMIN loopback[127.0.0.1]:33955).
ADMIN loopback[127.0.0.1]:33957).
ADMIN loopback[127.0.0.1]:33961).
ADMIN loopback[127.0.0.1]:33962).
expected output
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
i tried a lame procedure which won't work
cat 1.txt|grep -v [:12312]
thanks
text-processing ip-address
I have a file with IP and port numbers. I would like to take out the port number and leave the IP alone.
xyz 10.93.10.13:58160).
xyz 10.93.10.13:58161).
xyz 10.18.104.181:12466).
xyz 10.93.10.13:60585).
wxy 10.93.10.13:60586).
wxy 10.93.10.13:60587).
ADMIN loopback[127.0.0.1]:33955).
ADMIN loopback[127.0.0.1]:33957).
ADMIN loopback[127.0.0.1]:33961).
ADMIN loopback[127.0.0.1]:33962).
expected output
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
i tried a lame procedure which won't work
cat 1.txt|grep -v [:12312]
thanks
text-processing ip-address
text-processing ip-address
edited Aug 8 at 18:59
Jeff Schaller
32.4k849110
32.4k849110
asked Aug 8 at 18:54
ady6831983
83
83
add a comment |Â
add a comment |Â
2 Answers
2
active
oldest
votes
up vote
2
down vote
accepted
First, useless use of cat. Secondly, grep only searches; it does not change anything. You want sed here:
$ sed -E 's/:[0-9]+.*/ /' input
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
add a comment |Â
up vote
0
down vote
sed 's/(.*):.*/1/' filename should do the trick. Match everything before the colon and return that in the substitution.
add a comment |Â
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
First, useless use of cat. Secondly, grep only searches; it does not change anything. You want sed here:
$ sed -E 's/:[0-9]+.*/ /' input
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
add a comment |Â
up vote
2
down vote
accepted
First, useless use of cat. Secondly, grep only searches; it does not change anything. You want sed here:
$ sed -E 's/:[0-9]+.*/ /' input
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
add a comment |Â
up vote
2
down vote
accepted
up vote
2
down vote
accepted
First, useless use of cat. Secondly, grep only searches; it does not change anything. You want sed here:
$ sed -E 's/:[0-9]+.*/ /' input
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
First, useless use of cat. Secondly, grep only searches; it does not change anything. You want sed here:
$ sed -E 's/:[0-9]+.*/ /' input
xyz 10.93.10.13
xyz 10.93.10.13
xyz 10.18.104.181
xyz 10.93.10.13
wxy 10.93.10.13
wxy 10.93.10.13
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
ADMIN loopback[127.0.0.1]
answered Aug 8 at 18:57
DopeGhoti
41k55080
41k55080
add a comment |Â
add a comment |Â
up vote
0
down vote
sed 's/(.*):.*/1/' filename should do the trick. Match everything before the colon and return that in the substitution.
add a comment |Â
up vote
0
down vote
sed 's/(.*):.*/1/' filename should do the trick. Match everything before the colon and return that in the substitution.
add a comment |Â
up vote
0
down vote
up vote
0
down vote
sed 's/(.*):.*/1/' filename should do the trick. Match everything before the colon and return that in the substitution.
sed 's/(.*):.*/1/' filename should do the trick. Match everything before the colon and return that in the substitution.
answered Aug 8 at 18:58
Doug O'Neal
2,6271716
2,6271716
add a comment |Â
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2funix.stackexchange.com%2fquestions%2f461351%2fsubstitute-numbers-in-a-random-ip-address-port-with-space%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password