I am stuck on a script I am working on. The script reads a text file and parses each line and inserts semi-colons between the columns so that I can later easily upload the results up to SQL Server. Please see my attached script. Like I said I am stuck on some name columns. I need to match on a sting of characters like show below.
Supervisor Collector ——————– ——————– DEYOUNG,MR. RICHARD E MATIAS, SEAN J
Can someone help me with the code to match the name patterns in the two columns shown above? The Supervisor column will always be in the format ,. The Collector will always be in the format
These matching expression show be in continuation to the ones inline below for the $regex variable.