Registration is open for Inspire 2024! For today only receive up to 20% off. This promotion is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes. Register here!
Here is my approach > Used formula tool to clean up and parse upstream 1. I removed " and ' using REPLACE () in the formula tool 2. I converted the date string from 16-JUN-01 to YYYY-MM-DD using replace and regexp_replace I used Chat-GPT to help me with the syntax for both. I wouldn't know how to write this myself without looking at the documentation > Then used the Text to Columns tool to split by delimiter,