finstr | : chart_with_upwards_trend : Financial statements in R

I have a list of street addresses, some of which have po boxes. What I want to do is remove anything that isn't a po box from the line if it does contain a po box. For example, if there is a list of ['123 whatever drive', '234 anywhere lane po box 3213', 'po box 190 441 bettername street'] this should return ['123 whatever drive', 'po box 3213', 'po box 190']. All I have thus far is

I am currently working on automating data entry for a few look up tables in a SQL Server 2016 database. I am fairly new to SQL in general however have a few years of experience in Python. My issue is that if I don't have a value for each column in one of the tables that I am inserting data into, it throws the following error message at me.

I have a text file with one string per line (only a couple lines total). This file needs to be searched and each string stored. The script will ultimately prompt the user to choose one of the stored strings (if more than one string/line is present in the file), but the for loop is iterating an extra time when I don't want it to.

I'm using a counter to check the number of iterations, and I also read that it's probably a NL CR regex issue, but the finstr /v /r /c:"^$" in the for file-set like in this post Batch file for loop appears to be running one extra time/iteration doesn't work for me (but I probably don't understand it correctly).

The "pref" term is because the strings are to be eventually used as a prefix of files in the same folder...