AnsweredAssumed Answered

How do I automatically replace a (.) or a (/) with a (-)

Question asked by dansan500 on Feb 5, 2015
Latest reply on Feb 5, 2015 by philmodjunk

Title

How do I automatically replace a (.) or a (/) with a (-)

Post

If I have a field that contains [123-43/34.1896.12]

How can i automatically replace the (/) and the (.) with a (-)

so the filed information becomes [ 123-43-34-1896-12]

this works, but i don't know how to include the (/) to be replaced too.

Substitute (GetValue ( List (OEMpart ;MFGpart) ; 1 ) ;"." ;"-" )

Outcomes