我正在寻找一些帮助修剪URL在谷歌电子表格到根域,子域,子目录和URL。表格在A列中有子域和数值参数;我需要实现什么公式来获取根URL数据?
例如,我有一个名为https://www.web.stackoverflow.com/question/ask/how-to-trim-url-in-3-different format-with- gpf的url,但我需要这种格式的数据:First Column: https://www or https://
Second Column: stackoverflow.com
Third Column: web.stackoverflow.com
Fourth Column: stackoverflow.com/questions
Fifth Column: stackoverflow.com/questions/ask
Sixth Column: web.stackoverflow.com/question/ask/how-to-trim-url-in-3-different format-with-GPF
我试着用一些公式来学习它,但我不能。
尝试:
=INDEX(IFERROR(REGEXEXTRACT(A1:A, "^(?:https?://)?(?:ftp://)?(?:www.)?([^/]+)")))