Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA bit of regex to the rescue
Once you get the RegEx right, the rest is easier. I find .txt files are difficult to work with in general.
My RegEx code:
\|\s*?\d+\s*\|\s*(\d{3}-\d{2}-\d{5})|(\d{10})\s*(\u{2})\s*(\d{4}-\d{2}-\d{2})\s*(\d{4}-\d{2}-\d{2})\s*(.*?)\s*([A-Z][0-9])\s*(.*?)\s*\|