Hello. I have multiple fields in a dataset that have "-" as a value which I want to replace with a blank. However any replace function I try, it also replaces the -ve sign in the column. How can I avoid this? I only want to replace the entire dash value and retain the negative values.
Attaching is a sample dataset. This is the regex function I tried but it replaces negative values as well:
REGEX_Replace([_CurrentField_], "\-", " ")