Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI enjoyed that
This is a very clever challenge, I spent a long time figuring how to trim " and ' , then I decided to treat them both as delimeters then parse each record into 5 fields (date, mon, year are three fields), then I use formula tool to combine them all together back to a new field.... it worked but knowing how to deal with quotes and single quote in expression is very important. Thanks I have learned that from this challenge 🙂