Question
Replacing Null Values
I receive a binary file every month that I must read and
insert into a database. The file used to contain spaces when data
was omitted, and now it contains null characters. If I open the
file in a text editor like NoteTab Pro and replace all of the Null
characters with spaces, the file process correctly, but using the
file I'm getting without manipulating it only gives me part of the
first line.
Is there a way to replace all instances of NULL so that they're spaces? Or really any kind of character that actually shows up (not backspace, for example).
Any help is much appreciated, thanks!
Is there a way to replace all instances of NULL so that they're spaces? Or really any kind of character that actually shows up (not backspace, for example).
Any help is much appreciated, thanks!
