Search Results

Hi, try:

awk '
/SELECT *LISTAGG/ {
printf "--ignore begin\n%s\n--ignore end\n\n", $0
gsub(/LISTAGG[^)]*\)/,"CountMannuArray(&)")
}
{
print
}
' RS= ORS='\n\n' file
...

OK; how about - assuming you're in the .../check directory -
while read OP FN REST
do case "$OP" in
\#*) ;;
cd) SD="$FN"
...

A sed multi-liner
sed '/^ *[sS][eE][lL][eE][cC][tT]/{
i\
\\o grep org
s/^ */anyword /
:L
$!N
/;/!bL
a\
\\o
}
'
The loop appends the following lines until the end marker ; so...

Works for the data you showed: BEGIN {
RS=ORS="\n\n"
FS=OFS="\n"
}

{
A=B=0

for(N=1; N<=NF; N++) {
if(!A && $N ~ /^[ \t]*20[ \t]/) A=N
...

You can try this awk script. It looks for fields looking like dates, splits them into month, day and year and recombines them using a proper format.


BEGIN {
FS="|"
OFS="|"
}
{
...

Try alsoawk '{T[int(($1-1)/70)] = $1} END {for (t in T) print T[t]}' file
69
139
210
345
418
490
492

try also:
awk '
{
l=$1 % 70; if (! l ) c[NR]=d[NR]=1;
n[NR]=$1; m[NR]=l
}
END {
c[0]=d[0]=c[NR+1]=d[NR+1]=70;
for (i=0; i<NR; i++) if (m[i+1] <= m[i]) c[i]=1
for (i=NR; i>1; i--) if...

I think I see the pattern, but I don't understand why the desired output doesn't include the final line:
492

If you wanted that final line as well as the output you said you wanted, you could try...