Hi,
Newbie here. I have a V_String fields that contains Last name, First name, date and time. I'm trying to remove the last name, first name and time so that I'm just left with the date.
Ex - Smith, John K 2/18/2019 8:57:00 AM
The name lengths aren't uniform, so I can't do a "trim" .
Thank you!
Alison
Solved! Go to Solution.
I'd like to introduce you to my friend, RegEx. It performs pattern matching.
Regex_Replace([Field],".*(\d+\/.*)",'$1')
That formula will get you everything at the end of your string that starts with 1 or 2 digits followed by a slash.
Cheers,
Mark
Hey @AlisonK39
I'd be tempted to just parse out the date using the regex tool with something like: .*\s(\d+/\d+/\d+\s\d+:\d+:\d+ \w+)
An alternative (though similar solution to @MarqueeCrew 's post), would be to use the actual RegEx tool in parse mode with the following configuration...
Thanks so much - this worked perfectly!