Remove Special Characters from a field without using Data Cleansing

[Gandalf_NotGrey]

Hello,

I have a timestamp field which looks like this 2024-07-10 13:36:55

I need to remove the colon ":" from this field and keep everything else as it is.

The output should be like 2024-07-10 133655.

I tried this in the formula tool but could not do it.

Can someone please help me out with this.

Thanks so much.

[ShankerV · Accepted solution]

Hi @Gandalf_NotGrey 

This can be achieved with the help for Formula tool.

Replace([Timestamp], ":", "")

Note: The timestamp column might be in datatype date or datetime.

When using the formula tool, save the output in the different column name with datatype as VWstring

Many thanks

Shanker V

[Qiu]

@Gandalf_NotGrey 
Can you tell us which function you are using?

[flying008 · Accepted solution]

Hi, @Gandalf_NotGrey 

In new field, use the formula:

Replace(ToString([TimeStamp]), ':', '')

[Gandalf_NotGrey]

Thanks @ShankerV  @Qiu  @flying008  - This is working now. Thanks so much for your help.