UNIX for Beginners Questions & Answers

@vgersh99
Got your script to work but need to add sed '$!s/$/,/' | paste -sd ""

Code:

 awk -v str='x*.com' '$1~str && !a[$1]++' myFile | sed '$!s/$/,/' | paste -sd ""

to get my required output. Not sureif thats the best way, but I got it to work. Advice?

Thank you

A clunky way:-

Code:

grep -Ei "x.*\.com" /path/to/dir/file.html | sort -u > /path/to/dir/file.txt

The expression looks for an x followed by any number of characters followed by .com however this is not anchored to the beginning or end of a line. What is your input data like?

This input would still give some confusing results:-

Code:

x123@hello.com
x123@hello.com.foo
hello1@xyz.com
hello2@xyz.com
hello1@not-xyz.com-either

..... and lots of other variations. It leaves me a few questions::-
We are adjust the search to get just records you are after, but the search needs to be precise, e.g. does the line start with x or have x immediately after @; does .com have to end the line etc. All sorts of rules can be written if you can be sure what you want. If you could post a representative sample of your input and desired output (in CODE tags) then that will give us more to work with.




Kind regards,
Robin

You can use

Code:

awk '!a[$1]++' myFile | paste -sd "," -

If you want to replace each newline with ", " then

Code:

awk '!a[$1]++' myFile | sed -e ':L' -e '$!N;s/\n/, /;tL'