Search Results

$ awk -F\/ '/^title/{print a;print;a="";}/^http/{a=a","$NF}END{print a}' a.txt | sed '1d;s/^,//'
titleA
1234,6789
titleB
5678,1234
titleC
9123,1234,8912

Try also
awk '{printf "%s%s", (NF>1 && ONF>1)?",":LF, $NF; LF = RS; ONF = NF} END {printf RS}' FS=/ file
titleA
1234,6789

titleB
5678,1234

titleC
9123,1234,8912It would work also if the...

Another approach:
awk '{for(i=2; i<=NF; i++) sub(".*/",x,$i); sub(OFS,FS)}1' FS='\n' OFS=, RS= ORS='\n\n' file



--edit--
Yet another option:
awk '{gsub("\n[^\n]*/",","); sub(",","\n")}1' RS=...

awk -F'/' '
!/^http/ && NF {
T = $0
next
}
/^http/ {
A[T] = ( T in A ? A[T] OFS $NF : $NF )
}
END {
...

Hello Kibou,

Could you please try following.

awk '($0 ~ /title/){if(Q){print Q ORS $0;Q=""} else {print};next} {sub(/.*\//,X,$0);Q=Q?Q ($0?OFS $0:RS):$0;} END{print Q}' OFS=, Input_file
...

sed solution is fastest, doubt you'll be able to beat it by much (virutally immeasurable).

Maybe if we understood what you're wanting to do with the middle data?

Tested with a 2 GB file (excluding writing to a file which should be similar for all approaches):
$ time sed '1d;$d' greptestin1 > /dev/null

real 0m29.835s
user 0m29.186s
sys 0m0.591s
$ time...

I'm not sure why the sed solution (which, BTW?) should take significantly longer than the other ones posted. Would you mind to post some comparisons?

Let's say you have a managed system with two VIOs (vio1 and vio2) and a lot of fully-virtualized LPARs (lpar1, lpar2, ...).

If an LPAR has VSCSI connection, it must be connected to both VIOs.
...

How about fold -w 80

You'll see the difference when the maximum number of open files is exceeded.

by awk

echo "user lastname" | awk ' { print substr ($1,1,7) substr($2,1,1) } '

Since you did not answer the questions where are these names and what do you want to do with the combined names, the following is just an illustration of what it can be done.

#!/bin/bash
...

If we knew WHAT is "not working as expected" there might be a chance we could help. What's your OS, shell, awk version? What's the result of applying the solutions given to the small sample file you...

Using terms like "urgent" or "quickly" and/or bumping up posts is not THAT well received in these fora as people are volunteers spending their free time trying to help people solve their problems.
...

awk 'NR==FNR {T[$0]; next} $0 in T' file1 file2
2967 787

For that simple scenario, try grep -f file2 file1
2967 787

Actually \+ is a GNU extension.

In any sed (including GNU sed) one could use:
sed 's/[^0-9]*\([0-9]\{1,\}\).*/\1/'
or
sed 's/[^0-9]*\([0-9][0-9]*\).*/\1/'

--
In GNU sed one could use the...

Hi Kibou, in addition to what Aia said, the string s is empty when created, and then each time it is appended with the first field ($1) and OFS (by default a space), so the first time, s contains:
4...

Actually, they are not alone, it is the concatenation of all of them as in: s=s $1 OFS
OFS stands for Output Field Separator and by default is a single space

x is a variable that never gets a value assigned to it. sub(".*/",x,$1) in the field $1 substitute the first instance of ".*/" for "".

Hi, x is an empty variable, since it was not used before. In awk it automatically gets the value "" (in string context) when it is created. So it is another way of writing "" (the replacement part of...

This works with the English description of the desired output, but doesn't preserve the space between strings of digits as shown in the last line of the desired output. To get the desired output,...

Hello Mudshark,

Following may help you in same.

awk -F"|" '{Q=$3;gsub(/[[:alpha:]]|[[:punct:]]/,X,Q);sub(/^[[:space:]]/,X,Q);sub(/[[:space:]]+$/,X,Q);$(NF)=Q;if(Q){print $0 OFS}}' OFS="|"...

There are probably carriage return (windows) characters in your input file.
Convert your file to UNIX format first:

tr -d '\r' < MyFile.txt > MyNewFile.txt