regex - 正则表达式使用公式匹配 Google 表格中的换行符

Question

我有一段文字

➤ What is your Linkedin profile URL if you have not connected with on Linkedin?: test url
another
yet another

Need to make changes to this event?

我需要在哪里提取文本

**EXPECTED RESULT:**
test url
another
yet another

我试过了

=trim(REGEXEXTRACT($C$4,"\n.*➤ What is your Linkedin profile URL if you have not connected with on Linkedin\?\:(.*)Need to make changes to event\?"))

标签： regexgoogle-sheets-formula

Answer 1