Replacing a char with apostrosphe error

[Akeelah]

Hi
I am unable to replace char with an apostrosphe
Input value = Coquerel's Sifaka

Output = Coquerel''''''s Sifaka

Formula = ReplaceChar([Name], "[']" , " ' ") 

[Rhys_Cooper · Accepted solution]

Hi Akeelah. I reccomend using the regex tool rather than the formula tool for your use case.

The regex expression you need is (?:'). here the "?:" means match everything inclosed.

The screenshot below shows the configuration of the tool:

[Akeelah]

Thanks @Rhys_Cooper , this works , I am wondering if there is any workaround using REPLACECHAR

[BS_THE_ANALYST]

@Akeelah Any issue with just using replace?

The mistake you are making is with your logic. If you say replace "MYNAME" with "GRASS". The word "MYNAME" gets replaced with "GRASS". It doesn't replace each letter within "MYNAME" with "GRASS" rather the whole string itself.

I like the method I provided above and interesting you can't do "|"*6 and get "||||||" unlike python. Somehow I hacked this with the padleft function though so I'm not complaining. Every day is a school day.

All the best,

BS