Regards,
Reid Wahl (he/him)
Sent with Proton Mail secure email.
On Wednesday, February 14th, 2024 at 10:47 AM, Rich Shepard
<[email protected]> wrote:
> I've downloaded a data file where the permit type can be Active, Inactive,
> or Draft.
>
> Removing all Draft records was easy. Removing all Inactive records has so
> far escaped my gawk (and LO Calc) efforts because Inactive contains the
> substring 'active'.
>
> My script:
> BEGIN { FS = OFS = "," }
> NR ~ /1/ { print $0 }
> $4 == "Inactive" { next }
> $4 == "Active" { print $0 }
>
> I've also tried with matching:
> $4 ~ /Inactive/ { next }
> $4 ~ /Active/ { print $0 }
>
> And, of course, specifying only field 4 containing Active also fails.
>
> My AWK books and web searches haven't taught me how to write a pattern that
> matches only 'active' and not 'inactive.'
>
> Would the substr() function do the job? E.g,, substr(Active,1,6)
>
> Here are two sample records:
> 410 Auto Wrecking,410 Auto Wrecking,So3011780,Inactive,Industrial SW GP,27865
> Sr 410 E,Buckley,Pierce,98321
> 410 Auto Wrecking,410 Auto Wrecking,WAR011780,Active,Industrial SW GP,27865
> Sr 410 E,Buckley,Pierce,98321
>
> TIA,
>
> Rich
The `NR ~ /1/` line is causing the first line to be printed, regardless of its
contents.
