Hi Alteryx Community,
To begin with, I am no means of Regex expert. But I was wondering whether can Alteryx recognize the below pattern using Regex and create standardized columns based on the pattern below.
| From | To | Subject | Date | Attachments |
My current raw data example as below:
From:SeanTo:FishFlSubject:ReplicateDate:Monday,February,2023:02:01PMAttachments:XX.jpg |
From:ABCDTo:GEXFlSubject:A-ZDate:Thursday,January,2023:01:00PMAttachments:DADHA.jpg |
From:PattsTo:JeniSubject:unknownDate:Wednesday,October19,20232:51:00PMAttachments:djg.pdfimage001.ipq |
Appreciate if anyone can help shed light on this manner.
