remove hyphen from table box

[#1]

Hi,

I am getting hyphens instead of blank values in Tablebox, is there any setting I can apply to remove hyphens and display bank values?

[Digvijay_Singh]

hyphen means 'Null' as some of the field values are not associated with other field values of table box as per your data model. If you want to show null as blank in straight table, there is option in presentation tab at the bottom, don't think same option is there in table box. Through script we may convert nulls to other symbols but it has impact on aggregate formulas, count function will consider them.

Example from manual:

NullAsValue A,B; //A,B fields having nulls will be treated as values.

Set NullValue = ' ' ; //Null will appear as blank

Load A,B from x.csv;

[ramasaisaksoft]

Hi Vibhu,

is there any chance to use straight table instead of table box ?

if your answer is YES then change into Straight table and go to ->Presentation tab->Left hand side last  you can find 2 things

Null symbol   & Missing symbol boxes .

change there as per your wish.