nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Trimming/Removing characters from V_String

AlisonK39

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

Date Time

Accepted answers

BenMoss

An alternative (though similar solution to @MarqueeCrew 's post), would be to use the actual RegEx tool in parse mode with the following configuration...

All comments

MarqueeCrew

@AlisonK39 ,

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

LordNeilLord

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+)

BenMoss

An alternative (though similar solution to @MarqueeCrew 's post), would be to use the actual RegEx tool in parse mode with the following configuration...

AlisonK39

Thanks so much - this worked perfectly!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703