Replacing text mystery

HCL Domino Domino Forum
1

This is so lame I can’t believe I’m posting it here. I’ve been away from Notes for a while, but…

I have a text field called pwWebSite. Sometimes the entry in that field has “http://” and sometimes it does not.

I want to replace “http://” with nothing (and separately remove / if the field’s contents end with /).

I created an agent to run on all documents in the current view. I’ve tried @Replace(pwWebSite; “http://”; “”) and same with @ReplaceSubstring. I’ve tried escaping the /s, i.e., //. I’ve tried creating a variable with the content of pwWebSite and running the agent on it.

What on earth am I missing? Thanks.

2

Subject: Replacing text mystery

As a guess, you have

@Replace(pwWebSite; “http://”; “”)

and you should have

FIELD pwWebSite := @Replace(pwWebSite; “http://”; “”);

“”

as your agent code.

3

Subject: RE: Replacing text mystery

Thank you, Ben.

@Replace did not work, but when I changed it to @ReplaceSubstring it did.

I found I’d put SELECT @All in the document selection parameter (if that’s what that’s called, lol) and removing it in combination with trying @Replace and @ReplaceSubstring might account for why the one worked and the other didn’t.

It’s so nice to see all those entries cleaned up. Thanks again.