TrimRight with wild card?

Hi everyone

I am trying to use trimright to remove a specific number characters;

TrimRight([Ten-Minute Timeline],":*0:00") where the fifth character from the right needs to be a wild card to catch the minutes. When i run it it strips the last 4 characters but leaves behind the number of minutes. Is there a way to set this ?

Input

2023-03-01 09:40:00
2023-03-01 08:10:00
2023-03-01 08:20:00
2023-03-01 07:50:00

2023-03-01 09
2023-03-01 08
2023-03-01 08
2023-03-01 07

Thanks

Mark

Data Investigation

Accepted answers

Christina_H

You could keep it in DateTime format by using DateTimeTrim([Input],"hour")

All comments

ShankerV

Hi @mgirdwood

One way of doing this.

TrimRight with wild card.yxmd

binu_acs

@mgirdwood Basically the data is in DateTime format, if you want to only date part just update the dataType to Date

Date_130323.yxmd

Christina_H

You could keep it in DateTime format by using DateTimeTrim([Input],"hour")

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703