I was interested in what is ??
in Resident??s
.
I wrote a code to examine it.
import java.nio.file.Files
import java.nio.file.Path
import java.nio.file.Paths
import org.apache.poi.ss.usermodel.Cell
import org.apache.poi.ss.usermodel.Row
import org.apache.poi.ss.usermodel.Sheet
import org.apache.poi.ss.usermodel.Workbook
import org.apache.poi.xssf.usermodel.XSSFWorkbook
import com.kms.katalon.core.configuration.RunConfiguration
Path projectDir = Paths.get(RunConfiguration.getProjectDir())
Path xlsx = projectDir.resolve("Data Files/TorontoHousing-Site-Map-Content.xlsx")
assert Files.exists(xlsx)
FileInputStream file = new FileInputStream(xlsx.toFile())
Workbook workbook = new XSSFWorkbook(file)
Sheet sheet = workbook.getSheet('TCHC_Site_MAP')
assert sheet != null
Row row = sheet.getRow(2)
assert row != null
Cell cell = row.getCell(2) // Cell 'C3'
assert cell != null
println("'Residents'.length() is ${'Residents'.length()}")
String value = cell.getStringCellValue()
println("cell.value is ${value}")
println("cell.value.length() is ${value.length()}")
for (int i = 0; i < value.length(); i++) {
println("${i} '${value.charAt(i)}' ${value.codePointAt(i)}")
}
I got the following output
0 R 82
1 e 101
2 s 115
3 i 105
4 d 100
5 e 101
6 n 110
7 t 116
8 8203
9 8203
10 s 115
The UNICODE CodePoint 8203 is “Zero-width space”.