How to remove character and space from a string

Question

Hello I have one file with output

Name        : ABC
Name        : CDE
Name        : ZYS

I want to get the result

ABC
CDE
ZYS

How can i get it through SED command.

I have tried. sed s/'Name' but it returns me the output like: ABC

I want to trim the space and also : from the string.

jasonwryan · Accepted Answer · 2013-04-17 06:46:50Z

up vote 6 down vote accepted

You can use awk for this:

awk '{print $3}' yourfile

This simply prints the third field/column for every record/row.

answered Apr 17 at 6:46

jasonwryan
13k32150

Yes thats correct :) thanks – Moiz Apr 17 at 6:50

Baard Kopperud · Answer 2 · 2013-04-17 08:24:05Z

up vote 3 down vote

If you use sed:

sed 's/^.*: //' yourfile

or to be a bit more precise:

sed 's/^Name[^:]*: //' yourfile

answered Apr 17 at 8:24

Baard Kopperud
54510

1

take care, the first one is greedy and eats too much if there's a ': ' in the part right of the first ':'. – reto Apr 17 at 12:18

Thor · Answer 3 · 2013-04-17 08:40:53Z

up vote 1 down vote

With recent GNU grep versions you could do it like this with positive lookbehind:

grep -oP '(?<=: ).*' infile

Or more portably:

grep -o ':.*' infile | grep -o '[^ ]*$'

Output:

ABC
CDE
ZYS

answered Apr 17 at 8:40

Thor
4,671827

reto · Answer 4 · 2013-04-25 22:55:53Z

up vote 2 down vote

To complete the other answers with another way:

cat file | cut -d: -f 2-

you can cut out the remaining whitespace

cat file | cut -d: -f 2- | cut -c 2-

edited Apr 25 at 22:55

answered Apr 17 at 12:18

reto
1695

1

No need to use cat here. cut -d: -f 2- file works. – Evan Teitelman Apr 17 at 12:35

good point, thamks! – reto Apr 17 at 12:59

4 Answers