PARSE THE VALUE

[dunkindonut7777]

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

Date	Expected Output
2025-01-03T00:00:00	2025-01-03

Can you help me retain the date values?

[binu_acs]

@dunkindonut7777 

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

[binu_acs · Accepted solution]

@dunkindonut7777 

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

[aatalai · Accepted solution]

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

Left([Date], 10)

 

[jrlindem · Accepted solution]

@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