Challenge #2: Preparing Delimited Data

[MaxGiegerich]

Thanks for highlighting the TRIM function. New one for me. I used a multi-field formula, replacing ' and ". Not as succinct as the example answer, but intuitive and gets there in the end!

[patrick_digan]

Spoiler

[David92]

I feel there could be a more elegant solution than mine.  But it's a start in terms of participation. 

David

[Arianna_Fuller]

Spoiler

[data_rachel]

My solution

Spoiler

Spoiler

[jdunkerley79]

More catching up...

Spoiler

[hoheusle]

Notes included in the attached flow. Summary:

1. Use the Text to Columns tool

2. Use the Data Cleansing tool

3. Use the RegEx tool

4. Use the DateTime tool

5. Use the Select Tool

[mattwilliamson]

My solution to the challenge:

[marcreid]

My solution

[samjohnson]

Spoiler

More fun stuff. I am realizing that I'm committing a cardinal coding sin and neglecting to document my code. That needs to be fixed going forward.