Remove Special Characters from a field without using Data Cleansing

Question

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 Answer

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

flying008 · Accepted Answer

Hi, @Gandalf_NotGrey

In new field, use the formula:

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