Challenge #443: Mystery of the Unjoined Records

[beatriz_alteryx06]

Hi

Regex is almost always the answer.

Spoiler

[aasmith8116]

Tricky

Spoiler

[Sebastian_Chaieb2]

Trying not using Data Cleansing tool. Two proposal: 1- DataTypes; 2 - Regex tool

Spoiler

 

[Imaizumi]

Thanks for posting this. Different solution to the others, but I think you forgot to attach the actual solution and instead posted the start file.
Would like to be able to look at your flow.

[Imaizumi]

Thanks for the challenge. Really got me jumping down the rabbit hole.

Spoiler

[sophiezero]

The question is tricky, and the two whitespaces are invisible. Instead of the solution provided I use left/right function, the website is super useful!

Spoiler

[martinson]

ATTEMPT 1🏁

[snothando_hlongwane]

Challenge #443 Solution

[TobiasFitschen]

Spoiler

 

[AnaKomissaroff]

Here is my solution:

Spoiler