Grep words and paste is on the same line

say_hi_ravi · 10-31-2008, 02:02 AM

Hi Guys,

I want to write a program which should grep the strings(words) I desire and paste it horizontally with tab/comma separated.

e.g
$ cat test
JOB_NAME="lb2zerborg-xfer"
ftp-pgp \
--job-name="${JOB_NAME}" \
--debug=0 \
--ftp-passwd-file="${PASSWD_FILE}" \
--notify-success=abc@yahoo.com \
--report-failure=lmn@yahoo.com \
--report-success=xyz@yahoo.com \
--notify-success=ravmane@yahoo.com \

$cat test |grep JOB_MANE > test1
$cat test |grep notify-success >> test1
$cat test|grep report-failure >> test1

but this will print grepped stuff on separate lines
$cat test1
JOB_NAME="lb2zerborg-xfer"
--notify-success=abc@yahoo.com
--report-failure=lmn@yahoo.com

And i want all strings to be on same line. i.e
$cat test1
JOB_NAME="lb2zerborg-xfer",--notify-success=abc@yahoo.com,--report-failure=lmn@yahoo.com OR
JOB_NAME="lb2zerborg-xfer"(tab or space)--notify-success=abc@yahoo.com(tab)--report-failure=lmn@yahoo.com

Any help would be appreciated.

Thanks,
Ravi

burschik · 10-31-2008, 02:06 AM

Grep can't do that, since grep can not modify the content of the match to introduce tabs or commas. It would be easy to do with awk, or perl, for example, and possible to do with bash or sed.

Disillusionist · 10-31-2008, 02:54 AM

It's too early to think further than a bash script, so here it is:

Code:

#!/bin/bash
first_entry=$(cat test |grep JOB_NAME)
second_entry=$(cat test |grep notify-success)
third_entry=$(cat test|grep report-failure)

echo "${first_entry},${second_entry},${third_entry}"

ghostdog74 · 10-31-2008, 05:06 AM

Code:

var=$(egrep "^(JOB_NAME|--notify-success)" file)

say_hi_ravi · 10-31-2008, 06:07 AM

Many thanks Guys. Both of above solutions worked.
However I found one more solution...its bit lengthy compared to your solutions :-)

$cat test |grep JOB_MANE > test1
$cat test |grep notify-success >> test1
$cat test|grep report-failure >> test1
$cat test1|tr -s "\n" "," > test2

pwc101 · 10-31-2008, 06:26 AM

Quote:

Originally Posted by say_hi_ravi

Many thanks Guys. Both of above solutions worked.
However I found one more solution...its bit lengthy compared to your solutions :-)

$cat test |grep JOB_MANE > test1
$cat test |grep notify-success >> test1
$cat test|grep report-failure >> test1
$cat test1|tr -s "\n" "," > test2

You can make it slightly less lengthy by eliminating all the useless uses of cat

Code:

$ grep JOB_MANE test > test1
$ grep notify-success test >> test1
$ grep report-failure test >> test1
$ tr -s "\n" "," < test1 > test2

grep will happily read a filename as one of its arguments; tr however, won't, but you can use input redirection (<) to read the file in.

ghostdog74 · 10-31-2008, 06:53 AM

Quote:

Originally Posted by pwc101

You can make it slightly less lengthy by eliminating all the useless uses of cat[code]

there's also no need to use grep 3 times pass the same file.

pwc101 · 10-31-2008, 06:56 AM

Quote:

Originally Posted by ghostdog74

there's also no need to use grep 3 times pass the same file.

Yes, that's true, but useless uses of cat are one of my real bugbears, so I just had to point it out!

As you showed, a single grep is all that's needed