I tried to use replace and the cleansing tool to remove the space for the second row of chinese characters but it didn't work.
There is a big gap between the parentheses but when I highlight them, it is counted as 1 along with the space.
Any suggestions?
Solved! Go to Solution.
Hi @JinOnn
Can you post the actual text rather than a screenshot? This is probably a character that looks like a space but isn't actually the space that comes from your spacebar.
Try putting it into the below site to see what you're working with.
Open the file with something like a hex editor to determine what character is there and then you can use a formula tool with REGEX_REPLACE.
With the link that you provided, I was able to identify it as U+FF08 : FULLWIDTH LEFT PARENTHESIS, which is different from a regular parenthesis. Because of that I managed to use the formula tool to replace it with a standard parenthesis. My only question is, what is the actual purpose for a fullwidth left parenthesis compared to a standard parenthesis?
Thanks for your response. I used 'Replace' and it worked as well. I replaced " (" with "("