regex - 删除工作表中所有 URL 的指定部分
问题描述
我有一张包含多个链接的表格，所有链接的格式都是https://abc.xyz.com/randomstuff，我想abc.从所有链接中删除 。有没有办法在谷歌表格中为我自动化？
解决方案
尝试：
=ARRAYFORMULA(IFERROR(REGEXEXTRACT(A6:A16, "(https?://)")&
REGEXEXTRACT(A6:A16, "[^\.]\.+(.+)")))
推荐阅读
- javascript - How to close bootstrap popup on submit in VUE
- android - Dynamic/Encrypted Key in @SerializeName in android
- javascript - 我正在尝试编写一个函数，它接受 n 个整数参数并返回所有参数的乘积
- python - django models self.text attribute not returning the text
- python - Embed a plot into HTML using FastAPI and Jinja2
- excel - How to fill in blank cells in this column, when the cells have to be populated with different values from this same column?
- php - Update taxonomy field from ACF field when saving post
- android - How show hidden folder starting with a dot having a video file from android internal storage programatically?
- javascript - typescript/node/sequelize - How to add variables when getting dynamic value
- settings - How to correctly edit scalability settings/groups in Unreal Engine 4? To "overwrite" the default one's