您好,
我的文档库包含以下字段
I have Document library with the following Field
名称=文档名称将始终保留格式 2495703_58200_Kundan_Ghimire_United States_Application.pdf
Name = Name of the Document Will always be in Format 2495703_58200_Kundan_Ghimire_United States_Application.pdf
国家=需要根据名称列计算=美国。
Country = Needs to be calculate based on Name Column = United States.
我得到的我的Excel公式是
My Excel Formula I got is
= LEFT(MID(A2,FIND(&#;",SUBSTITUTE(A2," _","#) ",4),1)+1,9999),FIND(" _",MID(A2,FIND("#",替代(A2," _","#",4) ,1)+1,9999),1)-1)
=LEFT(MID(A2,FIND("#",SUBSTITUTE(A2,"_","#",4),1)+1,9999),FIND("_",MID(A2,FIND("#",SUBSTITUTE(A2,"_","#",4),1)+1,9999),1)-1)
这将有美国
This will have United States
当我尝试使用它并替换带有[姓名]的手机号码我收到错误,我甚至没有在可用字段中看到姓名列。
When I try to use this and replace Cell Number with [Name] i receive error and I do not even see the Name column in available field.
我有任何方式可以使用此
Id there any way I can use this
谢谢
Kundan
推荐答案
Hi Kundan,
Hi Kundan,
名称字段在计算列中不可用,默认为。
Name field is not available in Calculated Column, it is by default.
For您的要求,我建议您为li创建SharePoint 2013平台工作流程brary并使用 循环步骤和"在字符串中查找子字符串"实现它的行动。
For your requirement, I suggest you create a SharePoint 2013 platform workflow for the library and use Loop step and "Find Substring in String" action to achieve it.
您可以参考类似的常见问题解答:
There is a similar FAQ for your reference:
[论坛常见问题解答] SharePoint 2013:从启用多值的查找列中提取值,并将值合并到启用多值的列
谢谢,
Wendy
更多推荐
根据文档名称列计算值并显示国家/地区
发布评论