[Closed] Using awk to get 2 strings from a file

pedropt · 07-11-2017, 03:43 PM

Lets say that i have this file foo.txt

Quote:

John 0 56 admin
Marc 0 3 user
Peter 1 52 user
Alexander 3 65 user
...

I want awk to get variables : 1 and 4 from each line in that file .

And i want a final output file like this :

Quote:

John Role: admin
Marc Role: user
Peter Role: user
Alexander Role: user

I want to grab with awk the $1 and 4$ and write a new file output like it is before .

How can this be done ?

danielbmartin · 07-11-2017, 04:04 PM

With this InFile ...

Code:

John 0 56 admin
Marc 0 3 user
Peter 1 52 user
Alexander 3 65 user

... this awk ...

Code:

awk '{print $1,"Role:",$4}' $InFile >$OutFile

... produced this OutFile ...

Code:

John Role: admin
Marc Role: user
Peter Role: user
Alexander Role: user

Daniel B. Martin

astrogeek · 07-11-2017, 04:08 PM

You have given the answer in your question, all you need to do is give it a try! By the time you posted this question you could have had it working!

Substitute "print" for "write" and and format the print output using those fields.

**danielbmartin beat us both to it!

pedropt · 07-11-2017, 04:37 PM

Thanks i did not knew this was possible to do with awk

Quote:

print $1,"Role:",$4

I am on windows know , i will change to linux and test it and then i will close this threat if that is the case .

Laserbeak · 07-11-2017, 07:55 PM

Just for fun, here's a Perl version:

Code:

| => perl -e 'for (<>) {printf "%s Role: %s\n", (split/\s+/)[0,3]}' < role.txt
John Role: admin
Marc Role: user
Peter Role: user
Alexander Role: user
| =>

pedropt · 07-12-2017, 02:51 AM

It is working perfectly Daniel , sorry for the delay .
Also thank you laserbeak for the tip .

danielbmartin · 07-12-2017, 06:13 AM

Just for fun, here's a sed version ...

Code:

sed -r 's/([^ ]+)(.* )([^ ]+)/\1\ Role: \3/' $InFile >$OutFile

I consider this inferior to the awk solution in post #2 because it is less readable.

Daniel B. Martin

AnanthaP · 07-12-2017, 07:29 AM

just for fun.

There'a windoze version called gawk.

ok

Laserbeak · 07-13-2017, 01:12 PM

Quote:

Originally Posted by AnanthaP

just for fun.

There'a windoze version called gawk.

ok

gawk is really for everything. The Linux awk is really gawk.