Weekly Challenges
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,
