PARSE THE VALUE

Question

Hi can you help me how to remove the unnecessary characters using regex formula?

DateExpected Output2025-01-03T00:00:002025-01-03

Can you help me retain the date values?

binu_acs · Accepted Answer

@dunkindonut7777

Regex_Replace([Date],”(.*)T.*”,”$1”)

binu_acs · Accepted Answer

@dunkindonut7777

Regex_Replace([Date],'(.*)T.*','$1')

aatalai · Accepted Answer

@dunkindonut7777  if you are willing to use the left formula you might get a simpler solution

Left([Date], 10)

jrlindem · Accepted Answer

@dunkindonut7777

I respect that you likely have a reason for wanting to do this via REGEX, and @binu_acs has certainly addressed your question as is, but I'm altogether curious why re-assigning the data type in a SELECT tool isn't being leveraged as it is the absolute simplest solution...

Anyway, just another idea to consider if REGEX isn't absolutely necessary.  Cheers, -Jay