从一个细胞中提取一部分返回另一个细胞
我试图想出一个公式,这将采取网站的URL在一个细胞,提取什么是所谓的根域(website.com)没有www。或者https://或。com后面的任何url字符串
这里有几个例子的值,我在单元格和我想它返回水平单元格:
http://www.internationalrealestatedirectory.com/country/united_states/builders.htm->internationalrealestatedirectory.com
https://home-directory.biz->home-directory.biz
http://www.regionaldirectory.us/->regionaldirectory.us
在这个领域开始之前,有多个领域扩展和多个场景,这是可能的吗?如果是这样,我们将非常感谢您对公式的帮助。
最佳答案
-
她名叫Stara ✭✭✭✭✭✭
试试这样的方法。
首先添加三个所谓的助手列。
你可以叫他们,位置,包含,新
添加以下公式(URL列包含你的起始URL)
位置
=找到(“/”;(电子邮件保护))
包含
=如果(包含(“http://www。”;(电子邮件保护));替代((电子邮件保护);“http://www。”;" ");如果(包含(“https://”;(电子邮件保护));替代((电子邮件保护);“https://”;" ")))
新
根据您的国家/地区,您需要将逗号换成句号,将分号换成逗号。
这个URLhttp://www.internationalrealestatedirectory.com/country/united_states/builders.htm转换后将显示为internationalrealestatedirectory.com。
有意义吗?
工作/帮助吗?
我希望这对你有帮助!
注意安全,祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的答案.这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助,请随时与我联系。
0
答案
-
她名叫Stara ✭✭✭✭✭✭
试试这样的方法。
首先添加三个所谓的助手列。
你可以叫他们,位置,包含,新
添加以下公式(URL列包含你的起始URL)
位置
=找到(“/”;(电子邮件保护))
包含
=如果(包含(“http://www。”;(电子邮件保护));替代((电子邮件保护);“http://www。”;" ");如果(包含(“https://”;(电子邮件保护));替代((电子邮件保护);“https://”;" ")))
新
根据您的国家/地区,您需要将逗号换成句号,将分号换成逗号。
这个URLhttp://www.internationalrealestatedirectory.com/country/united_states/builders.htm转换后将显示为internationalrealestatedirectory.com。
有意义吗?
工作/帮助吗?
我希望这对你有帮助!
注意安全,祝你周末愉快!
最好的
✅我的帖子是否帮助或回答了你的问题或解决了你的问题?请帮助社区将其标记为可接受的答案/有用的答案.这将使别人更容易找到解决方案或帮助回答!
Smartsheet专家顾问和合作伙伴
W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35
如果您需要Smartsheet、集成、一般工作流建议或其他方面的帮助,请随时与我联系。
0 -
有一个方法提取链接URL从一个单元格?例如,文档Name包含一个URL链接(右键单击,我可以查看它)。可以在单独的单元格中提取或查看该URL吗?
0
帮助文章资源欧宝体育app官方888
You would use<\/p>
=PARENT([Focus Area]@row)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 20:21:04","updateUser":{"userID":120623,"name":"Umesh Shah","url":"https:\/\/community.smartsheet.com\/profile\/Umesh%20Shah","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!B_DAgW7inuQ!GutBH5L31vo!a4sw_iKY2Cf","dateLastActive":"2022-08-05T20:19:13+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":93984,"type":"question","name":"Multiselect Dropdown Parsing","excerpt":"Hello all, I have 3 columns in a sheet. 1 is a multi-select dropdown (\"MSD\"), 1 is a single contact (\"SC\"), and 1 is a multi-select contact (\"MSC\"). In the SC, I want to take the first dropdown value from the MSD and use it to index match a value from another sheet. In the MSC, then I want to take the remaining values from…","categoryID":322,"dateInserted":"2022-08-05T17:28:01+00:00","dateUpdated":null,"dateLastComment":"2022-08-05T19:48:02+00:00","insertUserID":151077,"insertUser":{"userID":151077,"name":"Allen M Vance","url":"https:\/\/community.smartsheet.com\/profile\/Allen%20M%20Vance","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wvjQf0zrtpU!HVPSXzyfi_0!-X5Gyhg_Kh5","dateLastActive":"2022-08-05T22:14:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":10,"score":null,"hot":3319449963,"url":"https:\/\/community.smartsheet.com\/discussion\/93984\/multiselect-dropdown-parsing","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/93984\/multiselect-dropdown-parsing","format":"Rich","lastPost":{"discussionID":93984,"commentID":338850,"name":"Re: Multiselect Dropdown Parsing","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/338850#Comment_338850","dateInserted":"2022-08-05T19:48:02+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2022-08-05T20:10:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-08-05T22:14:17+00:00","dateAnswered":"2022-08-05T19:48:02+00:00","acceptedAnswers":[{"commentID":338850,"body":"
Technically yes. You can pull these values in based on the multi-select dropdown, but...<\/p>
<\/p>
We cannot currently use formulas to populate multiple USABLE contacts in a single cell even if the column is set to allow multiple. It will simply generate a text string and won't be usable in automations for notifications, update requests, etc..<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"reasonUpdated":"","dateUpdated":"2022-08-05 22:14:17","updateUser":{"userID":151077,"name":"Allen M Vance","url":"https:\/\/community.smartsheet.com\/profile\/Allen%20M%20Vance","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!wvjQf0zrtpU!HVPSXzyfi_0!-X5Gyhg_Kh5","dateLastActive":"2022-08-05T22:14:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"title":"Trending in Formulas and Functions ","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">