Challenge #35: Data Cleansing Practice

[CaraI]

Missed posting this one from last year!

Spoiler

[RoDO]

My solution

Spoiler

regex to the rescue
1 REGEX_Replace([Field1], '^0+', '')
2 REGEX_Replace([Field1], '(^0+|[[:punct:]]|[a-z\s])', '')
3 REGEX_Replace([ID], 'ID$', '')
4 IF Length([Safety Code]) = 6
THEN 'SC' + [Safety Code]
ELSE REGEX_Replace([Safety Code], '[\w\s[:punct:]]{'+ToString(Length([Safety Code]) - 8)+'}$', '')
ENDIF

[Inactive User]

Here is the solution

[ashleyannyeong]

Can anyone help me understand the logic of the '\:.*$' in the 2nd Trimmed formula in the 2nd part of this challenge? I'm particularly struggling around the \: part. 

Thank you! 

[Inactive User]

The regex \:.*$ is trimming any whitespace, : and letters (a-zA-Z).

[mat_budden]

Hi All,

Please find my Results Below.

Spoiler

Used Formula's for all.

Thanks.

Mat

[tony_beck]

Spoiler

[sgrabish1]

Thanks for exercise

[Steph3388]

Lots of different ways to do this. Here's my way: