Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data showing blank and null

Dears,   I've got a strange thing. The data input is MySQL database. The Part Number column contains "Blank" and the ons look blank.  The "Blank" is really null, so IsBlank() returns "True". Howev...
Need Help
MFelix's avatar
MFelix
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

Onthe query editor try to find that specif record and make replacemente by null and see it works to make it blank.

 

Regards,

MFelix

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi, MFelix 

     

    Thank you.
    These cells are not really null, so Replace Values doesn't work for them. And I even don't know what's in these cells.