Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
For one of the column(ColA) I need to display as '---' if it is "blank" or '-'
If (trim(ColA)='-' or trim(ColA)='--' or trim(ColA)='.' or trim(ColA)='','---',ColA) as "ColA"
After applying this formula still it is displaying in the column as '-'.Please advise how it can be sorted it out.
Thanks in advance
Regards
RK
Is it possible that you have Null in there? Try this
If(Len(Trim(ColA)) = 0 or Trim(ColA) = '-' or Trim(ColA) = '--' or Trim(ColA) = '.' or Trim(ColA) = '', '---', ColA) as "ColA"