I am trying to replace a word that if the text contains the word "Feet" then replace it with the text that is only first 15 characters of the text.
My formula:
Replace ({_WorkOrder.ConfigProptext}, like "*Feet*", Char(15) "Romano")
Error: **A number, currency amount, boolean, data, time, date-time, or string is expected here.**
How to fix it please.
Best Answer
Apr 13 at 08:07 AM
No need to use replace if that is what you want
Try
If {_WorkOrder.ConfigProptext} like "*Feet*" then left({_WorkOrder.ConfigProptext}, 15) else {_WorkOrder.ConfigProptext}
Ian
Apr 13 at 01:37 PM
If you're trying to replace the word "Feet" with "Romano", try this:
Replace ({_WorkOrder.ConfigProptext}, "Feet", "Romano")
-Dell