Formulas

HCL Domino Domino Forum
1

I have two formulas I want to incorporate into the Input Translation for a field. They both work by themselves. I have tried using ;, |, and & but that doesn’t work. I don’t do this very often. Help would be much appreciated!

@UpperCase(@ThisValue)

@Trim(@ReplaceSubstring(@ThisValue; @NewLine : @Char(10) : @Char(13); “”))

2

Subject: Formulas

@UpperCase(@Trim(@ReplaceSubstring(@ThisValue; @NewLine : @Char(10) : @Char(13));

3

Subject: RE: Formulas

I did not post my response after yours, I tried the formula and I get Insufficient Arguments for @Function:')

4

Subject: RE: Formulas

Looks like I just accidentally lost a closing parenthesis when copying and pasting from your post.

5

Subject: RE: Formulas

Thanks for your help. I actually got the below from another developer as well. Both work.

tmp := @UpperCase(@ThisValue);

@Trim(@ReplaceSubstring(tmp; @NewLine : @Char(10) : @Char(13); “”))

6

Subject: Formulas

I tried the formula and I get Insufficient Arguments for @Function:‘)’