The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.
Announcement | We'll be doing maintenance between 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
Weekly Challenge
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
Completed
Spoiler
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,
> 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,
