Regex replace in a new column

[cltccross]

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.

[binuacs · Accepted solution]

@cltccross One way of doing this

[cltccross]

That was super quick! Thanks

[JamesCharnley · Accepted solution]

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:

[binuacs · Accepted solution]

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

[cltccross]

Thanks a ton, James. I wasn't even aware of string functions till now!

[cltccross]

This works best! Thanks a lot. I was using the Tokenize wrong, it seems.