General Discussions
Discuss any topics that are not product-specific here.
I had some trouble with my code, initially, but managed to identify and resolve the bugs I ran into quickly
It's about 'Parse'.
Spoiler
When complicated parse is needed, Regex tool will do it perfectly.
Part1: We need to parse out all pattern mul({inetger},{integer}), but not knowing how many exist. In this case, we can use 'Tokenize' into rows.
Please be careful when regex expression includes meta characters, they must be escaped by backslash '\'.
Then, data can be further parsed into columns to extract 2 integer values.
Part2: We need to extract more patterns 'do()' and 'don't()' in addition to 'mul({integer},{integer})'. Regex can be modified to match any of those patterns by vertical bar like (pattern1|pattern2|....|pattern N)
Then, by using Multi Row Formula, we can identify which record is to be calculated.
Part1: We need to parse out all pattern mul({inetger},{integer}), but not knowing how many exist. In this case, we can use 'Tokenize' into rows.
Please be careful when regex expression includes meta characters, they must be escaped by backslash '\'.
Then, data can be further parsed into columns to extract 2 integer values.
Part2: We need to extract more patterns 'do()' and 'don't()' in addition to 'mul({integer},{integer})'. Regex can be modified to match any of those patterns by vertical bar like (pattern1|pattern2|....|pattern N)
Then, by using Multi Row Formula, we can identify which record is to be calculated.
(Edit)
Tool golf version: Part1=3 tools, Part2=3 tools
Spoiler
Formula tool is very powerful!
Solved!
I should become closer friends with the RegEx tool.
Spoiler
But to simplify the regex, I used the Find Replace tool.
