在SharePoint计算列中查找字符串中最后一个字符 [英] Find last occurrence of a character in a string in SharePoint Calculated Column
问题描述
亲爱的朋友们,
在查找字符串中最后一次出现的字符时需要帮助。以下是我的要求。
我有一个字符串Ex:
1;#Item1;#66;#Item2;#18;#Item3;#67;#Item4
我需要提取右侧文字最后出现的字符#。在上述情况下,它是"Item4"。 。我需要在SharePoint计算列中执行此操作,其中替换不会像Excel一样工作。
在此先感谢...
这应该这样做!
=右([列名],LEN([
列名
]) - INT(FIND(<
#",[
列名
])))
Dear Friends,
Need help in Finding last occurrence of a character in a string. Below is my requirement.
I have a string Ex:
1;#Item1;#66;#Item2;#18;#Item3;#67;#Item4
I need to Extract Right Side text of last occurrence character # . In the above case it is "Item4" . I need to do it in SharePoint Calculate Column , where substitute wont work as like Excel.
Thanks in Advance...
This should do it!
=RIGHT([Column Name],LEN([
Column Name
])-INT(FIND("
#",[
Column Name
])))
这篇关于在SharePoint计算列中查找字符串中最后一个字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!