# in text importer

[Kent]

I have a text file that I want to import, but it has #NULL! in some of the data fields, which I want to replace. I am putting an entry in the SQL function field to do this, but of course the # is being replaced by the data when the import runs. Is there a way to specify the # as a literal in the SQL function so that it doesn't get replaced?

thanks.

 

[Marco Kalter]

You can use the expression CHR(35)||'NULL!' in the SQL function.

 

[PFay]

Thanks.
I spent several hours trying to figure out this one before finally finding this posting. It would be helpful to explain this in the app or at least the Users Guide.