url - 谷歌表格函数将字符串转换为可读 URL

Question

我搜索 google-sheets 函数将字符串转换为可读 URL

string: "dies ist ein String in Deutsch mit scharfen ß und lästigen blöden Umlauten"

网址：“dies-ist-ein-string-in-deutsch-mit-scharfen-ss-und-laestigen-bloeden-umlauten”

• Ä 到 ae
• ü to ue
• Ö 到 oe
• a 到 ae
• ü 到
• ö 到 oe
• ß 到 ss
• “空间”到——

标签： urlgoogle-sheets

Answer 1

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A2), 
 "ä", "ae"), 
 "ü", "ue"),
 "ö", "oe"),
 "ß", "ss"), 
 " ", "-")

---

对于数组采取这个：

=ARRAYFORMULA(IFERROR(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LOWER(A2:A), 
 "ä", "ae"), 
 "ü", "ue"),
 "ö", "oe"),
 "ß", "ss"), 
 " ", "-")))