Replace Function ? - how to replace the a 4th position null with a dash

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
 
Solved
CompanyID4: IIf(Len([CompanyID4L])=3,[CompanyID4L] & "-",[CompanyID4L])
 

Users who are viewing this thread

Back
Top Bottom