份额计算栏
我想从 sharepoint 2007 的“电子邮件发件人”列中获取电子邮件地址。任何人都可以帮我编写公式来获取电子邮件 ID。
old value : abc, def <[email protected]>
expected value: [email protected]
如何编写表达式以便我得到类似的内容。请帮助我我
在计算列中添加了类似下面的内容，但不知何故我无法撕破“>”符号
=MID([E-Mail From],FIND("<",[E-Mail From])+1,FIND(">",[E-Mail From])-1)
和 o/p 是
[email protected]>
I would ike to get just the email address from the column :Email From" in sharepoint 2007. Can anyone please help me wrting the formula to get the email id.
old value : abc, def <[email protected]>
expected value: [email protected]
How to write the expression so that i get something like that. Please help me.
I have added something like below in the calculated column, but somehow i cannot rip '>' symbol
=MID([E-Mail From],FIND("<",[E-Mail From])+1,FIND(">",[E-Mail From])-1)
and the o/p is
[email protected]>
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看起来你已经拥有了；也许这个调整？
MID([电子邮件发件人],((instr("<",[电子邮件发件人]))+1),((instr(">",[电子邮件发件人])) -1））It looks like you have it; maybe this tweak?
MID([E-Mail From],((instr("<",[E-Mail From]))+1),((instr(">",[E-Mail From]))-1))