Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA@PhilipManneringcool RegEx solution!
I couldn't quite replicate the output, but here's some version of it using an iterative macro for practice and less code than I'd usually use for fun.
I think there's a minor error in the provided solution as it does not mask the first character of the 2nd record and it should be masked according to the instructions and provided example. Since the mask/not mask resets with a new record and every 1st character should be masked. I used a long formula to account for that.
Phenomenal use of RegEx by PhilipMannering above. Check out his 1 tool solution!
It took me a while to get the logic (longer than the programming). Great puzzle!
Thanks for posting this solution! I was curious to know why you chose to use the following expression in your Multi-Row Formula tool and a breakdown of what it means - specifically the Row-1 part?: IF Regex_Match([Data],"\s") THEN 0 ELSE [Row-1:Character Number]+1 ENDIF
My solution.
In my interpretion, it states that "Your task is to mask every other letter in a word with an asterisk. " but the answer is consistent with "Space" wise.