Question Re: SAP Crystal Report - Replace formula syntax in Technology Q&A

SAP Crystal Report - Replace formula syntax

former_member1347830 — Fri, 01 Oct 2021 07:13:08 GMT

Hi,

Please share the syntax for REPLACE function in SAP Crystal Report. We have SQL datafield BOOK NO . it is STRING. I need to FIND character , and REPLACE with EMPTY string

REPLACE({CurrentFieldValue},",","") -> throws error

Re: SAP Crystal Report - Replace formula syntax

former_member763929 — Fri, 01 Oct 2021 07:13:18 GMT

Thank you for visiting SAP Community to get answers to your questions. Since this is your first question, I recommend that you familiarize yourself with Community Q&A , as the overview provides tips for preparing questions that draw responses from our members.

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

Re: SAP Crystal Report - Replace formula syntax

former_member1141152 — Fri, 01 Oct 2021 12:06:39 GMT

Hi, I couldn't quite understand the question.

If you were to replace any type of character within a string the syntax of the replace function would be the same in this example.

Inside the {Command.test} I have a string with the value := "123.abc.456"

If I use -> replace({Command.test},".","")

The result will be the treated string would be "123abc456" without the point it was asked to take.

Now if what you need is to treat an empty or null-valued string, I suggest treating it with a condition first, because as the value is empty you cannot pass an empty value to the function, in the function it will read as if you had not passed it parameter.

IF ISNULL({Command.test}) OR {Command.test} = "" THEN "NOT_string"

ELSE {Command.test}

Then in this case you would have a value to pass as a parameter of the replace function, which would be the "NOT_string", but this case is very specific, because with the condition you did, what the replace function would do.

REPLACE(

(IF ISNULL({Command.test}) OR {Command.test} = "" THEN "NOT_string"

ELSE {Command.test}),"NOT_string","_")

Re: SAP Crystal Report - Replace formula syntax

DellSC — Fri, 01 Oct 2021 13:39:50 GMT

Or, easier than going through all of that, in the Formula Editor, change the null handling for this formula to "Default values for nulls" instead of "Exception for nulls". This will automatically replace a null field value with an empty string. Replace will work with any string value - even an empty string - but it throws an error on a null.

-Dell