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'.
Hi @Inactive User,
It looks like you are using the replacechar function when you actually want the replace function.
Greg
Hi @Inactive User
You need to use Replace instead of ReplaceChar
ReplaceChar finds each char in the string and replaces it.
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?
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 🙂