正则表达式拆分字符小练习

龙逸凡

来一道正则表达式小练习练练手，用一个正则函数实现。对正则表达式感兴趣的朋友可以做一做。


要求
请分别在B4、B6、B8、B10单元格用正则表达式函数编制公式，将B2单元格的“偷懒有术工作有闲人生有味”拆分成第4、6、8、10行所示的样式：
每个单元格一个字符，各字符间有一空白单元格，最前最后的空白单元格或有或无。


结果如下图所示：






偷懒的技术读者群牛魔王给出的公式字数

jerrike

1.

1. =REGEXP(B2,"|.")
   
2. =REGEXP(B2,".??")
   
3. =REGEXP(B2,".*?")
   
4. =REGEXP(B2,"\B|.")
   
5. =REGEXP(B2,"\K|.")

复制代码

2.

1. =REGEXP(B2,"(?!^)|.")
   
2. =REGEXP(B2,"(?<=.)|.")
   
3. =REGEXP(B2,"(?!\A)|.")

复制代码

3.

1. =REGEXP(B2,"(?!$)|.")
   
2. =REGEXP(B2,"(?!\z)|.")
   
3. =REGEXP(B2,"(?!\Z)|.")

复制代码

4.
=REGEXP(B2,"(?!^|$)|.")
=REGEXP(B2,"(?!\A|\z)|.")
=REGEXP(B2,"(?!\A|\Z)|.")

zhumumu1816

感觉是不是CONCAT函数更简单

loirol

=REGEXEXTRACT(CONCAT(REGEXEXTRACT(A1,".",1)&" "),".",1)

我走我流

参  和  下，
=TRIM(REGEXEXTRACT(REGEXREPLACE(A1,"(?<=(.|^))"," "),"[\s\S]",1))
=TRIM(REGEXEXTRACT(REGEXREPLACE(A1,"(?<=.)"," "),"[\s\S]",1))
=TRIM(REGEXEXTRACT(REGEXREPLACE(A1,"(?<=(.|^))(?<!$)"," "),"[\s\S]",1))
=TRIM(REGEXEXTRACT(REGEXREPLACE(A1,"(?<=.)(?<!$)"," "),"[\s\S]",1))

无关岁月

1. =REGEXEXTRACT(REGEXREPLACE(B$2,""," "),".",1)

复制代码

1. =REGEXEXTRACT(REGEXREPLACE(B$2,"(?!^)"," "),".",1)

复制代码

1. =REGEXEXTRACT(REGEXREPLACE(B$2,"(?!$)"," "),".",1)

复制代码

1. =REGEXEXTRACT(REGEXREPLACE(B$2,"\B"," "),".",1)

复制代码

mengrs

=REGEXP(REGEXP(B$2,CHOOSE(INT(ROW(B2)/2),"\B","(?<!^)\B","\B(?!$)","(?<!^)\B(?!$)"),2," "),".")

龙逸凡

我走我流 发表于 2025-1-14 09:40
参  和  下，
=TRIM(REGEXEXTRACT(REGEXREPLACE(A1,"(?

试着用一个正则函数搞定试试

无关岁月

28还得想想

1. =REGEXEXTRACT(B2,"|.",1)

复制代码

1. =REGEXEXTRACT(B2,"(?!^)|.",1)

复制代码

1. =REGEXEXTRACT(B2,"(?!$)|.",1)

复制代码

1. =REGEXEXTRACT(B2,"\B|.",1)

复制代码

我走我流

龙逸凡 发表于 2025-1-14 14:02
试着用一个正则函数搞定试试

谢谢指导，换个思路
=REGEXEXTRACT(A1,"(?<=.)|(?=.)|.",1)

ww87725244

我走我流 发表于 2025-1-14 15:50
谢谢指导，换个思路
=REGEXEXTRACT(A1,"(?

还可以简化一下
=REGEXEXTRACT(A1,".*?",1)