Search Results

Is it possible to e.g.

sort -t, -k2,2 -k4r -k3 file

try:
awk '!/,/ {a=0} /,/ && a++ {FS=OFS=","; $0=$0; $1=$2=""} 1' infile

Try:
gawk '
{ for(i = 1; i <= NF; i++)
if((n = split($i, f, ";")) > 1) {
o = ""
for(j = 1; j <= n; j++)
o = o "[" f[j] "]"
$i = o
}
}
1' FS=, OFS=, out
where out is a file...

Try:
gawk '
{ A[i = $6]
for(j = 1; j <= 5; j++)
if(!((i, j, $j) in d)) {
d[i, j, $j]
outd[i, j] = outd[i, j] ? outd[i, j] ";" $j : $j
}
}
END { for(i in A)
print outd[i,1],...

Change -F '[][:]' to -F '[]:[]' instead.

Or:
awk -F '[][:]' '{gsub(/,[[:space:]]*/,";")} NF>1{print $1 "," $3}' RS=/ file

Orawk '
/:$/ {sub (/:/, ",")
n = split ($0, T, "/")
printf "%s", T[n]
}
/^initia/ {while (!/]$/) {getline X
...

Another approach:-
gawk -F'[][,/:]' '
/storage-views/ {
name = $(NF-1)
next
}
/^initiators/ {
flag = 1
}
...

Hello greycells,

Following may help you same, could you please try it and let me know if this helps you.

awk '/^\/clusters\/*/{if(A){print A;A=""};gsub(/.*\/|\:/,X,$0);A=$0}...

How about awk -F"," '
FNR == 1 {FC++
}
FC < 3 {a[FC,$2]=$1
next
}
{X = Y = "N/A"
n = split...

With the assumption that storage-view: ALWAYS precedes the respective virtual-volume:, a CNT of 0 indicates there hasn't been a storage-view when the virtual-volume is encountered, and it creates an...

You're not too far off. Try awk '
/storage-view:/ {SNAME[++CNT]=$2
}
/virtual-volume:/ {VV=$2
HA=$4
BA=$6...

I see, ok, try:
awk '
{
i=$3 FS $8
p=(i in A)
}
NR==FNR {
A[i]=A[i] (p?";":x) $2
B[i]=B[i] (p?";":x) $6
next
}
p {
$2=A[i]
$8=B[i]
delete...

Hello greycells,

Could you please try following and let us know if this helps you.
Let's say we have input file is as follows.

cat testt1...

This works if the patterns don't repeat further down the file. For e.g. AU01NAS002,FCNVX133800117,AU01_Melbourne_Australia,ATT,Internal,NAS SILVER,12287.99,3293.98,6946.02...

awk 'x[$1,$2,$3,$4,$5]++{$1=$2=$3=$4=$5=""}1' FS=, OFS=, infile

Modification to your original attempt. Try:
awk 'NR==FNR{a[$1]=$2;next}{for (i in a) sub("[^,]*" i "[^,]*",a[i],$2)}1' FS=, OFS=, /tmp/reference /tmp/input

or

awk 'NR==FNR{a[$1]=$2;next}{for...

From the looks of the results, would it be fair to say that you want the name of the first subdirectory in column two, that is if column two has /a/b/c/d, the result should be "b"? If so, a small...

Change the definition of @K to:
my @K = qw{ name root access ro rw comment };
If the square braces are cosmetic, then change the print to:
print $dir, map { defined $O{$_} ? $O{$_} : '' } @K;...

The problem is the field separator occurs in the field. For example:
export "/0014apps/test folder" name="/reet" root=10.200.12.29:10.200.12.32 access=10.200.12.29:10.200.12.32
to be split into...

It does not help leaving the windows <CR> line separators in your sample. Get rid of them first.

Then tryawk 'BEGIN {nK=split ("name root access ro rw", K)}
...

Something like:
BEGIN {
FS = "\" \"|\" | \"";
OFS = ",";
}

{
split($3, P, "/");

N = "<unknown>"; # netbios name
n = split($4, A, "[ =]");
for (i = 1; i <= n; i += 2) { if...

For given sample input this will work

Either setting FS
awk -F'"|=' '{split($4,A,/\//); print A[2],"["$2"]("$NF")","["$4"]"}' OFS=, infile

OR lengthy match
awk '{print...

A perlish solution:
$ perl -ne '
@F = m{^[^"]+"([^"]+)"\s+"(/([^/"]+)[^"]*)".*netbios=(\S+)}i;
print $F[2], ",[", $F[0], "](", $F[3], "),[", $F[1], "]\n";
' file...

Not too elegant - mayhap the printing should be done the way you implemented it - but it seems to give what you requested:awk 'BEGIN {print "Symmetrix ID,DEV,Storage Group Name,Port...