如何删除SharePoint计算字段中的字符 [英] how to delete characters in a SharePoint Calculated field

问题描述

我想从一个计算列中，通过删除下面的内容后的所有内容来获取另一列中的数据

示例：我得到" SharePoint _London_2019"我希望得到" SharePoint "在此计算列中。

I would like from a calculated column, take the data from another column by removing everything after the underscrore
Example: I get "SharePoint_London_2019" and I want to get the "SharePoint" in this calculated column.

有没有办法做到这一点？

Is there a way to do this ?

谢谢

推荐答案

 试试这个

 Try this

= LEFT（Title，INT（FIND（" _"，Title）-1））

=LEFT(Title,INT(FIND("_",Title)-1))

这篇关于如何删除SharePoint计算字段中的字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！