Challenge #496: Create the Correct Code

[Yoshiro_Fujimori]

My solution.
Not matched with the expected result.
I'll wait for the solution next week.

Spoiler

Workflow

Formula Tool #1
[Code2] = ReplaceChar([Code], "-_", "")
[Part1] = REGEX_Replace([Code2], "[\d].*", "")
[Part2] = REGEX_Replace([Code2], "^\u+", "")
[New Code] =
  [Part1] + "-" + Left([Part2], 3) + "-" + Substring([Part2],3,2)
[New Code] =
  IF IsEmpty(Substring([Part2],5,1))
  THEN [New Code]
  ELSE [New Code] + "-" + Substring([Part2],5,1)
  ENDIF

Formulat Tool #2
[HasLetterSuffix] = IF REGEX_Match([Code], ".*\u$") THEN 1 ELSE 0 ENDIF
[Malformed] = IF [Code] != [New Code] THEN 1 ELSE 0 ENDIF

Formula Tool #3
[% of total with letter suffix] = ToString([Sum_HasLetterSuffix] / [Count] * 100) + "%"
[% Code Missing Delimiter] = ToString([Sum_Malformed] / [Count] * 100) + "%"

[alineruizcampos]

My solution matches everyone else's!

Spoiler

[Imaizumi]

Task 1 was completed, but need a minor correct. See solution

Task 2 I could finish the suffix, but percentage I dont quite get. Need to wait for solution

Spoiler

[RolandSchubert]

Spoiler