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
My solution.
Spoiler
Workflow
Formula Tool 1
Start = CharToInt(Substring([tag],4,1))
End = IF [Start] = 0 THEN 0 ELSE CharToInt(Right([tag], 1)) ENDIF
Formula Tool 2
New_Tag = Left([tag], 4) + CharFromInt([Start])
Formula Tool 1
Start = CharToInt(Substring([tag],4,1))
End = IF [Start] = 0 THEN 0 ELSE CharToInt(Right([tag], 1)) ENDIF
Formula Tool 2
New_Tag = Left([tag], 4) + CharFromInt([Start])
Great challenge
Spoiler
assumed that all tags of 5 characters or less was correct, and used generate rows, converting the suffix letter to unicode number
