怎么通过switch函数实现数据为空时显示‘-’ 数据不为空显示原值。
if 更简单 if(len($$$)==0,"-",$$$)
switch($$$,"","-",
" ","-",
null,"-",
$$$,$$$
)
switch($$$,'','-')
用IF写不行吗
IF(LEN($$$)=0,"-",$$$)