Hello.

Yes, I'm aware of the many discrepancies but worried I am taking too much of your generosity!

I still have a lot of pre-processing to do on the raw text. A lot of replace & regex is still needed for sure. With the amount of data i was 'assuming' this would be a lot of trial-error before I get it close. This is part of why I was hoping the CASE statement could put the data in the corresponding field.

Rather than take any of your time than needed could you kindly look at my pseudocode and advice on proper syntax - that would be awesome!!