# Bug: Complex file reader prepends "invisible space" to first colum name of utf-8 input file **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [September 2, 2022, 10:55am UTC](https://forum.knime.com/t/bug-complex-file-reader-prepends-invisible-space-to-first-colum-name-of-utf-8-input-file/46686 "2022-09-02T10:55:29Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Experimenter](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/5daacb/32.png) [@Experimenter](https://forum.knime.com/u/Experimenter)\ **Post date:** [September 2, 2022, 10:55am UTC](https://forum.knime.com/t/bug-complex-file-reader-prepends-invisible-space-to-first-colum-name-of-utf-8-input-file/46686/1 "2022-09-02T10:55:29Z")
Topic overlaps with closed [BUG: File Reader mishandles UTF-8 BOM - #2 by bjoern.lohrmann](https://forum.knime.com/t/bug-file-reader-mishandles-utf-8-bom/21842/2) I am dealing with this for several years already. So when trying to read utf-8 CSV file with Complex File Reader, it looks all normal, but actually first column name has invisible space prepended. This leads to hard-to-debug consequences, like [visually] duplicate column names in same table, suddenly failing aggregations when switching data input, etc. Any hopes to get this handled? 🙂 Result of concatenate of same file (3 columns, ccy, rate, dte), read with Complex reader and CSV reader: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/0/5/0552f6f3f0e3162fcd77d2f6bbf2f5ed165eaaa4.png) ![image](data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAJ8AAABWCAYAAADR/EScAAAMwUlEQVR4Ae2dv48kRxXHm9QBOPEPwUkYH+KML+CM5IEx+CxxlgMgMvnR0Uj3JzgwOlu6cbbyX2BdaHEjIdl4E47Eka1jUwtvZl1iEbArYQkQQaH3qr6vXtVU9/zq7p2dfivNdnd1/epXn3qvqutNTeWcc+++9z4d7G8DCTz77FX3q1u/dp999nmS6s6dO8m1XTRLoKJbgO/x48fOPuvJ4KmnnmOp/uKXt9xHH33Mcrt//74DfCbHdjmSrJbgOz8/d/ZZLYNnnnleuvTN195wDx/+1eXwmRyb5Wjw7dDRNHxEIQH49tt/SDSfwbeH8J2dzN1kMncnZ2eXVsvm8BGAP37xJffmm79jjUhmdxv4DkE26zx3p5rvbFG7qqrip140Cn9fBbyoK1et2SlK8BF137tylSchGr59k818otpJtdlkftLYZusAtUmczuA7mU9cVdVuoTTZok6vdcX2ET4Cb1LXa2vkJvgIQJoF0ySEnnmfZXOR7dAJfGdnJ24+mbj5SdmE8gNK7/JA4qH/9uhe0thpeO3q0EPrBZXhe2u9OHOINydNFfKm8NjYIXwy5zBfh+Y6EiDU65HvOsOBNvj+89//OZoF0yRkn2SjFQCdl56X5AxZnp0tXF1N3L0/UTvF9iCZSxwaQkn7Vo0c5GV3Ax8XXtZyvvKxoqwF6oU8dCt8lYfFmyx1Ppk7TqcFQCZfwmNdoH3b4AN4TY2RCw3XbfCR9js//5e7ObnuXqx+m1gEpB9aNqUOVYKP5R2GTDjP5efbpHYP/vnA1criIT88Y9uxO/gm87KAs4mFf4jaPQgarxW+MPbCA5HwcN6YjoVBWi8C2CYAugeNCg3KxzXGfavgIwC//vof7tvfue7e+8vDpbEUngVQ9C0blKPlkdeB7vlO4eVHQxFtaZBHohGV1vMyXE/23cAXVHPJ7OYPN4SAGVKu02YQsuCzzqIbKj9fBz4C8KuvHrurkzcuDXz0nB46MrkepKV2TMzxdm8tOoGPKts0qPZqeYXZrWp55cL5wHxuo/ke3XO1mrFhvOWhbx7zAaxcyAgvHXP4vvnm38Qa/9GEg8Z89Hn5h0+76ls/SCwDDQeGlg20ln6Wpuf18qp4HEzx83hsdqmdgqXB+E/nveq8M/ioIA9gnABUGDckA9LlnqTTYbapzap+cJzr+1o4EAZMKF4deGH2Bx+B98QTT7uP//yQ4bv1+m/cBx/cF22nn5HrdgGy2QQ+kik6rsg3Ma/RtHrZqnZfY8hCeXYKH2U4pg80H8Cjme2VKz9i+MjUXrv20qWVBzQbgEWnx3UX7Wzw7dBhCD4NHjXIT278zH36qfdyIe334Yd/vJQAYqIByAy+HUCBELs80loumVrSeMiX1naffPK7rP2++OLv7vr1l+Ue4tjRW0jTfB0DTQL9/nPXHIFHfzduvGLwNch4CT4KsM9uMrh9+7Z74YWfuldvvu7eeeddk2cLU+LPR06Q9jEZDMmAwGdjkW5m63fv3mWTa/9WS8DgaxiTbNsZDb7V0CGGwWfwgYXBjwafwTc4dCjQ4OsLvtMjN1VLUtOjUy9zCp8euXCFdlh9L415EFcJfPAxw9oou9OIh4hfv/v9g0fshoTFZLjXlLxath03XeZ0fsx37GbV1IE3547dbHY8SsDaekkCn/ZiJQC8l3L0SgEUcDLkOOTI2fJ9DaQZyzHCN3MBNyX/U3c0jYvwP3/rLdaCRzMKm7lPglb8Mhx9uI8Pdl2mUasmLapK3ddTga+0flcKY+BYG3rPhnwdcCyQNT0nZrvHDFTlKqEmIKDNbgBJooR7DF9VOQk/njmC7EvSoDpc57WvhLXUayv4SPC5w2FTY4wtHPCJzAkcGvuBJA2MPqcEGj6t0VaEF8ePUoH9PYnw8ReBlk1sbooBE2vFKjocInzsxyX4uO1JYwUzrIHT5+vAFzSgwJan31/OijUT+AgaAJVMOBJn0Ajnqm+tjRVCho+ggKZTUPEYkO5VMz/bzeEJ1xjz5ZB5s6smMnn6YhPvb2AC3ybA5A6Hm6Q95Lhe86UTC+rMcebrHMaDmHAsQZZDpa9hxvEaR5vn/eWsWLOt4bOJRnktuGx2i7LfPZBA1Bp29xwHzWFr+A5Ze+3ybH3DB63ph0al1zmD8rNTYQZfXyscOzXLOBILfNRj7WMyGJIBgW8XU2Np4/ivb7N7SDrR4DOze2E8G3wG3+WCr2nN18zvOY+be2lN/a6vwwLY0SF/XdNTWXm1t9J8Bl8c4+Udjsd81HhV5cSHj6S+a4Pumj5vea7StPyesIeyCsXH3egBlN9w0XuspHuMhD3ywhowluBkU0W8ca/W3yAwb7hDuBb4pjM3m3a4FNY5ELnPocKj87JU3upUNB/WdeEkmoMAHz5a0wWotHeH3s+N0uBenn4s1xG+I3eqVyBCgzau2/J9Ahb+e3GJjq1iSI/7yZId3VOdn5fyQnz4Ci75FpacFFQe4ieY5N3tS+0UvmyHIQAJLYfNsgEYw5c5Hvi4cRejsUCH50zgc34dV8PTCh+8n3n9NmjNAIn38Yua9PRoqnz8FBQBOjid5sM5KB5KH4cFZT/B3H+Qy2zKEBlvcGyEz4MXtxVbAq6wfx4aYMzHHD4Z6wUoWuGDk0CIyw4Hbeng/aw1Fp9Hr2hxWsigSODT5VG8FWUuadEs73Uv2+FTmpDHfxq4sKkjvvfRZK7HBmIOHzU+NfTsyH9xqBf4AK1u9RwofS/USTRfHvei4SNoyHMFJhcbN5KppQ/ulSYcMM9jA4+etwQff4GINBK5wlPDwp8PM06EAyINQwMI0QRmJhOQ6TwQpo/BnPugdPLBeRfc9mOZQTvCQZYyCc8lWjG/1mWHc9F8YwSlj2fO4ROZqwE+N2IwldPZjL9ElGhEDU4499BGZYAJgZhmbXqnR2I6m8yu7xBxDOl4nOnzR52W887GlgZf8zu3PuBalSfDJ8Tt90miyS6gqqb5Rr68VlzhGAhEg2/k8A3EWbEYgY/MhX1MBkMyIPCtGsvY/fXGlpdpzFdURwMGGnxmdgfELS2qET69omFabz2tR3IyzZcC1na1FnwGosHXBtG29wy+Pswuv93v2J8PLbxt3oUX180voFFYv8cEPu9MoN6i84+7+f34ZJkNP4qs3qjb3nxRM7LZ5Ybu2J8PHGybt4YPeV3wUeDLHQS0qU3O1fZoNMbBPRsXegAjfGV/vsYlqwBHcU8+DQkgouUwuDchDGvFSjH4bTqibyApEWzTgXVmWY/lLdjCEhrluZSPrsju5xG+7LdmAZX47CUeLUo7cgXH67+Xd7oEvpI/X7bHnixxhcYGT7zWCkcD3c4KNNq9gOOrMB2V8/AR0rVeFV/yoIQCNDkaZOu4tF7c8d928ClXq1z4Y7/O4YNv3Glo8MSBgBqTwuGXp2FTgGhHBGgt0aCURsX1+SnlgDzzOAgX4Ii94GjAdVJ5sIJRMHYEYYQv/Ho0xm/mvxfHcZt0qBw+goTgafXnWwFf0tYKomLe8IYG2IBMpZMOwRmTSSawjt2sFDcpvNsLgY8EzN/TCHbe/Pe6gy/x52szu2j8HBzd5goi1n4hP/EVVHmwxsQ1a7PyvoDcOci1S/Zxa/AR1PVAHXPz3HadpU/g26SHW9wynLnmE3mTeUtAgFlTA3zcR8Pqa2Sk4EOQHh/qXay0Xx6BinuJ6UZZGhoJQx29I6yHXUqVIYNMWALgjdcqKZ0afH2858uEbJdlCRh8Bl+ZjAFCDT6DbwDMykUIfDRWsY/JYEgGBD6bQJQnEJvKhScc5Y5uoZkEDD4zuxkSw10afAbfcLRlJRl8Bl+GxHCXBl9f8PEL1/iSVlYPSi+J0d5t9xDngI4JfHCrgu+e/d7u5pMQP+FIt5+w39st95gEvtKP/JXCsFcfzQT1+aYzw0OMr+GTZSYle/u93SgMgU/77wGKUhgDpxxK7WewUu2IVy1YRxWHT8hcm9ZgmsWHL9zDviwSHtaF8/3yUu8UFHB5jlvBRwB66BaursyRFJ2VjoBPECBwyFMIJOXwaecBDd8G4UsL/lL4fp9E+Oz3dp2GaNvzJfi4/ZVn8C7wac8Yylfntd+cFWsn8JGw2cwGfz7qrTzhyLa9xSaQ9nu7qbkFrAwfQQFNpyDhMSDdw/58OTzhuujtLPvlqW3N8vTFJt7fwAQ+CHCdI080zJ1+SVt6zZd+YYc6svhprvKryzeKVPCyeYUZh5LQ5nl/OSvWbGv4bKLRovmKou4hkEDUGraHIvrMcmv41tGOY4xTHvN114Qyi2bN1/2Xerqr6eqcDL6+VjhWy370MQQ+6rH2MRkMyYDAN0YTac9cHrcOJReDr2OzO1TDHUI5Bp/Bt/S6aCiw/w+RK8iCNCYaFAAAAABJRU5ErkJggg==) ---
**Author:** ![Experimenter](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/5daacb/32.png) [@Experimenter](https://forum.knime.com/u/Experimenter)\ **Post date:** [September 2, 2022, 11:48am UTC](https://forum.knime.com/t/bug-complex-file-reader-prepends-invisible-space-to-first-colum-name-of-utf-8-input-file/46686/2 "2022-09-02T11:48:55Z")
UPDATE: this is an autonomous fix: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/0/50a91b5e1bf7a6a49805fcadc175b58d5b68a8d7.png) Java code: `return (int) $${SColumn 0}$$.charAt(0) == 65279 ? $${SColumn 0}$$.substring(1) : $${SColumn 0}$$;` Colum rename is controlled by variables. ---
**Author:** ![denisfi](https://forum-cdn.knime.com/user_avatar/forum.knime.com/denisfi/32/83308_2.png) [@denisfi](https://forum.knime.com/u/denisfi)\ **Post date:** [September 2, 2022, 9:12pm UTC](https://forum.knime.com/t/bug-complex-file-reader-prepends-invisible-space-to-first-colum-name-of-utf-8-input-file/46686/3 "2022-09-02T21:12:11Z")
It occours because of encode tuype from file and from the text content… UTF8 need to be the same for both cases… If the file is other type or the content (ISO, Windows/mac…) this caracter wi’ll be present… try to convert you file and contento for the same encode type first. For CSV file, you can choose the encoder as default: ![image](https://forum-cdn.knime.com/uploads/default/original/3X/8/2/820c0742b56040b981b977356f1ec50f34c33bda.png) ---
**Author:** ![Experimenter](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/e/5daacb/32.png) [@Experimenter](https://forum.knime.com/u/Experimenter)\ **Post date:** [September 5, 2022, 9:31am UTC](https://forum.knime.com/t/bug-complex-file-reader-prepends-invisible-space-to-first-colum-name-of-utf-8-input-file/46686/5 "2022-09-05T09:31:34Z")
Of course, the file encoding is similar to what is configured in reader node. The bug appears when configuration is correct. ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [December 4, 2022, 9:32am UTC](https://forum.knime.com/t/bug-complex-file-reader-prepends-invisible-space-to-first-colum-name-of-utf-8-input-file/46686/6 "2022-12-04T09:32:16Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.