iTranslated by AI
The content below is an AI-generated translation. This is an experimental feature, and may contain errors. View original article
😎
What to Check When Strings Don't Match
co.jp
co.jp
The strings don't match. Here are my notes from when I investigated this.
1. Investigation of full-width, half-width, etc.
I copied and pasted it into VS Code to check. Nothing seemed out of the ordinary...
2. Character code confirmation
It looks like there's a space. It's not a regular half-width space either. When I checked the character code, it turned out to be a zero-width space. What on earth is that!
This time, I decided to use a formula to remove the zero-width spaces. I confirmed that they match after applying this formula.
=ARRAYFORMULA(substitute('入力'!A2:H,"",""))
Others
Discussion