techexpressinc
Registered User.
- Local time
- Today, 13:34
- Joined
- Nov 26, 2008
- Messages
- 185
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],"","-")
Any suggestions?
Thanks Russ
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],"","-")
Any suggestions?
Thanks Russ