characters dropped in formula

Question

Hi, i was wondering if anyone could help me out and explain why the 'o' in 'nov' is being dropped in the output of my formula.

As you can see the formula works fine for 'oct' (and all other months) but I dont understand why it won't work for 'nov'.

Capture 3.PNG

Capture4.PNG

atcodedog05 · Answer

Hi @Inactive User

Here is the explanation so When you are using ReplaceChar([Field],"From","")

It considers characters separately F,r,o,m all case sensitive.

So since Nov has 'o' its replaced becomes Nv. But since Oct has upper O and not lower o its not replaced.

In similar way F is replaced from Feb becomes eb. But M is not replaced from March because different case

Replace considers complete string only replace word From not alphabets.

Hope this clarifies 🙂

unknown · Answer

Hi, this my result from using the Replace formula rather than ReplaceChar - i am still not achieving the desired result.

I still dont really understand why the issue is happening in some months and not in others?

atcodedog05 · Answer

Hi @Inactive User

You need to use Replace instead of ReplaceChar

ReplaceChar finds each char in the string and replaces it.