topic Re: Formula to remove first three characters from a alpha-numeric string in Discussions

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

tajrida — Wed, 13 May 2020 17:32:51 GMT

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

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

txnelson — Wed, 13 May 2020 18:00:18 GMT

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

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

tajrida — Wed, 13 May 2020 18:44:15 GMT

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.

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

txnelson — Wed, 13 May 2020 22:05:10 GMT

attach a sample data table please

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

tajrida — Wed, 13 May 2020 23:34:32 GMT

Thanks. Attached here is the test data file

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

txnelson — Thu, 14 May 2020 00:11:51 GMT

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

Substr(:Preparation date, 5)

and it worked without issue. See my attached file