Challenge #2: Preparing Delimited Data

[Nicholas_White]

Hi,

My second Weekly Challenge 🤣

Spoiler

Thanks,

Nick

[Nicholas_White]

Hello,

@Antonio1969 

The original date:

16-JUN-01

Its format is broken up like this:

16: dd

JUN: Mon.

01: yy

When you put this back together with the hyphens, the format looks like this:

dd-Mon.-yy  

So, if you select dd-Mon.-yy as your format, the date will convert.

Try that format in the DateTime tool, and it will work.

Good luck,

Nick

[Pete_Rodgers]

first attempt, using tools and minimal code

Spoiler

[erickyaparevalo]

Hi,

first time sharing solving a weekly challenge here. Here you can find my solution. In fact, they are two. One using RegEx tool and another using Formula tool with RegEx inside. Maybe someone will find it interesting to check some basics on RegEx. Learning Regex step forward your level on parsing data. I encourage you to skill on it!

[bwins]

Spoiler

[Angelica_Obi]

My first Alteryx challenge completed 

[CammyPhillips]

My Solution :)

Spoiler

[Muhammadmaaz]

My Soultion

[JHerzog5839]

Spoiler

[Daniel_DB]

Thanks!