We currently have a feature that we update monthly for the public as it pertains to certain facilities. In that feature class there is a field called "Fax Phone". In that field it contains both fax numbers and a string '( ) -' if a location does not contain an actual fax number (instead of it being empty it contains ' ( ) -').
My goal is to create an expression that states: If the fax phone field equals '( ) -' then show up blank. If it does not equal ' ( ) -' show the fax phone number.
IIf($feature.FaxPhone == '( ) -', '', $feature.FaxPhone)
This is my current expression but it does not seem to work properly because it still showcases the '( ) -' on my pop-up (image below).
If anyone has some insight I will greatly appreciate it!
Thank you,
Josue
Code looks fine, I might take a wild guess that you have a trailing space (which makes sense if there's some concatenation happening previously to generate that string), so maybe test for that.
'( ) - '
Building on what David suggested:
IIf(Replace($feature.FaxPhone, ' ', '') == '()-', '', $feature.FaxPhone)
Also, make sure you're actually showing the expression in the popup, not the field.