Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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
This one took a lot longer than it might otherwise have done due to some sneaky data issues!! 🙂
I also played along with the Easter Egg, which was fun but the icons we have now are much easier to read so I'm grateful that they were updated.
My solution :
Spoiler
I have included two data channels to highlight to users not already aware that the Float data type can sometimes introduce inaccuracies when converting from strings.
I fiddled around with various different versions of the Regex I used to extract the values before I was able to overcome the difference in format at the end of the very long strings in 3 of the rows. These discrepancies were very naughty hiding where they were hard to spot because of the lengths of the strings, but then strange things do happen with data from some systems so it was a good exercise.
I fiddled around with various different versions of the Regex I used to extract the values before I was able to overcome the difference in format at the end of the very long strings in 3 of the rows. These discrepancies were very naughty hiding where they were hard to spot because of the lengths of the strings, but then strange things do happen with data from some systems so it was a good exercise.
