I'm a newbie to the forum and hope you can help me with the following problem I have.
A record can be closed automatically or manually. When closed manually the operator enters his comments. But when closed automatically, I need to leave the comments blank.
The field looks like : [#7618|18160200044]
The first two digits are always the same "[#".

What I would like to is to make an SQLexpression, to look for these strings and delete the sting for the report.

I can filter on the "[#" with the startswith function, but not replacing the value. I also tried it with IF - ELSE - THEN function, but then values are also filtered out.

Can anybody help me?

Thank you for the quick answer, but I think  I need it a little different.

All records that start with [#, I would like to show them blank, as if there was no comment applied for that record.

Thank you, it worked