Extracting Date from Email

[KamenRider]

Hi guys,

Is there a way I could get the date in the email below using Alteryx automation or other means aside from copying and pasting it using the report text tool in Alteryx?

I'd like to get or extract "Wed 5/8/2024 6:29 PM" and convert/format it to "Wednesday, May 08, 2024 6:29 PM".

I'd like also to extract "20240508 06:28:41" exactly as it is.

Anyone please. Please help.

Kamen

[Deano478]

@KamenRider you could do this very efficiently with Power Automate or Automation Anywhere 

[KamenRider]

Thanks @Deano478 , however our office don't have power automate. How about python, any ideas? Guys from out there please.

Kamen

[Raj]

@KamenRider 
use outlook email tool to pull the data from the mail
once pulled this can be converted using the formula tool.

[KamenRider]

HI @Raj,

Is that the outlook input tool? can you please give an example how this is being done. It seems it has space for password?

 

Looking forward for your assistance.

Thank,

Kamen

[KamenRider]

HI All,

Hi All / @Raj  @Deano478  @binuacs 

Does anyone of you knows how to extract date and message like using python in Alteryx?

Need assistance please.

Kamen

[Raj]

@KamenRider 
body and datetime received will pull the required.

[Raj]

.Edited.

[KamenRider]

HI @Raj 

What do you mean. Do you any idea to share with?

Please advsie

Kamen

[BS_THE_ANALYST]

@KamenRider you put a picture of how to configure the tool. Raj said click on the body and datetime checkboxes to pull the info you want from your request