Search Results

Try the awk script below...
awk '/^<ClientName>foo<\/ClientName>$/,/^<\/Client>$/ {if($0 ~ "^<64bit>false</64bit>$") $0="<64bit>true</64bit>";print}' clients.xml

That approach would work fine if it were modified to use the correct number of consecutive n commands.

That sed script does not require -r.

Regards,
Alister

I don't get why you need ssh -n (-n option). But it won't affect what we are doing.
One easy way to get a status is to echo one. We use OK NOTOK


st=$(ssh me@myhost 'some command >/dev/null...

Is this what you're trying to do?


awk -F, 'NR==1{for(i=1;i<=NF;i++)if($i==v)c=i};NR>1{print $1" "$c}' v=engine foo

awk # obviously
-F, # use comma as the field seperator
'{ # begin code to run
for(i=1;i<=NF;i++) # loop over fields in record maintaining position...

It means for every line: loop through the fields, if a field matches the variable v then print the field position.

This script seems a bit strange to me, since it will just produce field numbers...

The A[$1] before the code block: A[$1]{$5=A[$1];print}

nulls and blanks are considered false and won't run the code, anything else is true and will run the code block.

Try:
awk -F, '{for(i=1;i<=NF;i++)A[$i]=i;print "The field "v" is on position "A[v];delete A}' v=IDENTIFIER infile
or without arrays:
awk -F, '{for(i=1;i<=NF;i++)if($i==v)print "The field "v" is on...

When FNR==NR (the first file is being read), load field 2 ($2) into array with index of field 1 ($1), until FNR!=NR then the second file starts (and the first section of the script is now skipped)....

Yes, that is correct. Awk uses so-called associative arrays..

What do you want to do with the very long SQL statements? Do you want to indent them on second/third lines?

BTW: This is what perl was designed for:

#!/usr/bin/perl
format =
@###### ...

Ok, since you already used arr[$1] to create an empty array element with the index of field 1, I used that to give it the value of field 2 instead, which then later gets referenced in the second...

Try:
awk -F, 'FNR==NR {arr[$1]=$2; next} $3 in arr {print $2,$4,$5,arr[$3]}' OFS=, file1 file2

Welcome to the forum!
You can use the inverse:
awk 'FILENAME=="target" {arr[$0]++}
FILENAME=="lookup" {if(!($0 in arr)) {print $0}}' target lookup

I noticed and I adjusted my response as well :)