AnsweredAssumed Answered

How to replace special characters using the if-function.

Question asked by timraudies on Jun 15, 2018
Latest reply on Jun 15, 2018 by timraudies

Hi,

 

I am currently trying to replace the content of a text field with a simple if calculation.

Currently, I am storing Foot/Inch Sizes in this field, incl. the special characters ' and ''.

I want to replace all of them with just 4 numbers.

Examples:

12'10'' > 1210

9'5'' > 0905

10'4'' >1004

8'0'' >0800

 

How can I position the additional "0"s at the right positions and how do I get rid of the special characters?

Thanks for any help!

Outcomes