Skip to Content
avatar image
Trish Fernandez

Crsytal Report error in my REPLACE formula

Apr 12 at 09:40 PM | 30 Views

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.

SAP Crystal Reports
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Ian Waterman
    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Dell Stinnett-Christy
    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

    Add comment
    10|10000 characters needed characters exceeded