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

[JBevan89]

Spoiler

 
Like everyone else, not sure on why question 2 has a different percentage.  Perhaps there is a logical reason?  because there it is a trick question, or is it just a mistype?

[Qiu]

I also abit off with the provided solution, but I think I am correct.

Spoiler

[balajilolla3]

Spoiler

Solution Attached

[alacoume]

completed wthout matching the solution! 

Spoiler

[abacon]

I also didn't get the answers to match the output but my answers matched everyone else's so I feel good with it. A fun one that make me brush up on some REGEX.

Bacon

Spoiler

WorkflowTask 1Task 2

[clewis28]

Spoiler