Formula to remove first three characters from a alpha-numeric string

[#1]

HI,

How do I remove "Thu" from the alphanumeric string "Thu 01/02/2020 10:42 PM" using and assigning a formulae, to a column.

I tried using below formulas and it doesn't work. what am I doing wrong?

1. left

2. right

3. word

4. substr

[#2]

If the column you are reading from is actually a character column, and not a numeric column with a format applied to it, then the substring is what you want to use.  Make sure the column is a character column. and if so, the below will work

a="Thu 01/02/2020 10:42 PM";

b=substr(a,5);

The formula version of the above code if the original column is called "MyColumn"

substr(:MyColumn,5);

If not then you just need to change the format for the column

[#3]

Your suggestion is working fine for other character columns in the table BUT not for the column with specific format i.e., 

a="Thu 01/02/2020 10:42 PM";

I also checked and verified column properties to ensure it is a "character" column. 

[#4]

attach a sample data table please

[#5]

Thanks. Attached here is the test data file

[#6 · Accepted solution]

I created a new column and placed this formula in it.

Substr(:Preparation date, 5)

and it worked without issue.  See my attached file