I have a field that I need to replace the 4 character in with a dash when the position is null.
Sample of input values:
ABC
GATE
HAV
ROAD
Output values wanted:
ABC-
GATE
HAV-
ROAD
I have tried this and variations without success:
Outputfield: Replace([Inputfield],"","-",[4,[1]])
Any suggestions?
Thanks Russ