Challenge #35: Data Cleansing Practice

[Watermark]

Spoiler

 

[jestinejoseph]

Spoiler

Regex code for last task.

IF Length([Safety Code])=6 THEN PadLeft([Safety Code], 8, "SC")
ELSEIF Length([Safety Code])>=8 THEN REGEX_Replace([Safety Code],"([\s\S]{8})([\s\S]+)","$1")
ELSE Null()
ENDIF

[James_Bell]

I took a similar approach as others. I didn't use regex as they did in the published solutions but still arrived at the same result using formula and strings.

[theNeilRichards]

My solution attached - thank you for the challenge!

[Tubalady]

Here is my solution

[summit_view]

Answer

[r_manju02]

Here is my solution

[AsmiDesai]

Tools used:

- Filter & Select

[geoff_zath]

Spoiler

[MollieC]

See my solution below 🙂