@ReplaceSubstring未按预期显示值 [英] @ReplaceSubstring doesn't display value as expected

问题描述

我在Lotus Notes数据库的视图中的其中一列中有此公式.但是，它不会更改视图中字段"EmployeeName"的值，并且仍显示原始名称.

I have this formula in one of the columns in my view in Lotus notes database. However, it does not change the value of the field "EmployeeName" in the view and still displays the original name.

示例: 原始 值:Franco Martínez, José Ramó 预期 输出:Franco Martinez, Jose Ramo

value1:="i";
value2:="e";
value3:="o";

optionList := value1:value2:value3;
aliasList := "í":"é":"ó";


@ReplaceSubstring(@Text(EmployeeName); aliasList; optionList)

推荐答案

由于公式绝对正确，因此问题必须出在其他地方. 您已经检查了该字段为摘要，因此这不是问题.

As the formula is absolutely correct, the issue has to be somewhere else. You already checked, that the field is summary, so this cannot be the issue.

请检查列的程序名称(属性中的最后一个标签): 它是否恰好与同一视图中的另一列匹配，或者可能是"EmployeeName"?然后只需删除该名称，它就会以一个新的唯一名称重新填充.

Please check the programmatic name of the column (last tab in the properties): Does it happen to match another column in the same view or is it probably "EmployeeName"? Then just remove the name, it will be repopulated by a new unique name.

说明: 重复的程序名称意味着两列显示相同的值，并且第二列的公式永远不会执行.如果列名中有一个字段名，那么无论公式怎么说，该字段名将始终显示该字段的值.

Explanation: Duplicate programmatic names mean, that both columns show the same value, and the formula of the second columnn is never executed. If there is a Fieldname in the name of the column, then it will always show the value of that field, no matter what the formula sais.

另一种解释可能是í"<>í" ...可能其中一个是另一个Unicode-字符的表示，只是碰巧看起来像另一个Unicode-字符...您可以检查一下使用仅@@ replacesubstring后提示值的按钮或代理，或将字段内容复制到十六进制编辑器中.

Another explanation could be that "í" <> "í"... Probably one of them is the representation of another Unicode- Character and just happens to "look" like the other one... You can check this using a button or agent that just @Prompts the value after replacesubstring, or copy the content of the field into a Hex- Editor...

您也可以尝试使用@Ascii()-@Function转换为ascii，而不必替换字符.

You could also try the @Ascii() - @Function to convert to ascii without having to replace characters.

这篇关于@ReplaceSubstring未按预期显示值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！