Regex replace in a new column

Question

Hi Community,

I'm new to this tool, and hit a roadblock on what might be a simple task. I need to extract the date from URLs and write the dates alone to a new column. Is there a way to do this on Regex? I'm only able to replace the current cell as it is using the expression (\d+)[-](\d+)[-](\d+)

Any other simpler way to do this would be great as well, if there are no Regex solutions.

regex.jpg

binu_acs · Accepted Answer

@cltccross One way of doing this

JamesCharnley · Accepted Answer

Hey @cltccross I'm glad you got a solution quickly! If you're interested in learning you'd be able to do this without Regex using string functions with something like this:

binu_acs · Accepted Answer

@cltccross Another approach that you followed using the Regex Tokenize method