Challenge #35: Data Cleansing Practice

[duartepimentel]

Solution attached

[dfurlow]

Regex and Trim to the rescue!

[minam]

Last one was tricky!

These links helped:

https://help.alteryx.com/20212/designer/regex-tool

https://www.boost.org/doc/libs/1_76_0/libs/regex/doc/html/boost_regex/syntax/perl_syntax.html

[BenFr]

Plenty of good data hygiene practice!

[kcfuiks]

Solution attached.

[VizChic]

FG AA soln

[mneun815]

My solution.  

Not sure if anyone will see this here, but I had a question about using wildcards in a formula tool.  

For the second output I used a formula Trim([Trimmed],": Report"), and while this works to achieve the correct output, I was trying to figure out a way to trim any text where there was a colon and any characters after.

Is there a way to achieve this using a Wildcard in the formula?  Any help is appreciated, thanks!

[SimonEvans]

Spoiler

[Patrick_Silveira]

solved. thanks

[carmenrapariz]

Spoiler