AnsweredAssumed Answered

Nulls In Text Imported by Folder

Question asked by briancrockett on Jul 24, 2018
Latest reply on Jul 24, 2018 by beverly

I have a folder full of text files. (XML Files From the Database Design Report) I want to import them so that the text content goes into a text field.


I don't have any problem actually doing the import but when I try to parse the text it fails.

When I copy the text out of the text field it has a <NUL> character between each regular character.


So instead of looking like ABC it looks like A<NUL>B<NUL>C<NUL>. If I open one of the original files in a text editor it's fine.


I took a look at the data with a Hexeditor and a <Nul> is actually ASCII/ UTF  value 00.


Any idea how to fix this?


FM 16, MacOS.