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.

Outcomes