上下两行内容合并正则有办法能实现吗

This topic created in 1042 days ago, the information mentioned may be changed or developed.

em 正则有办法能实现吗，或是多步骤能否实现

效果前
〖 BH 〗 AAA 〖〗〖〗〖〗〖〗 0.020 〖〗-0.017
〖 BH 〗〖〗〖〗〖〗〖〗(0.027)〖〗(0.015)
〖 BH 〗 BBB 〖〗〖〗〖〗〖〗-0.225**〖〗 0.018**
〖 BH 〗〖〗〖〗〖〗〖〗(0.113)〖〗(0.009)
〖 BH 〗 CCC 〖〗-1.087***〖〗 0.413***〖〗〖〗-0.966***〖〗 1.033***
〖 BH 〗〖〗(0.147)〖〗(0.081)〖〗〖〗(0.175)〖〗(0.323)

效果后
〖 BH 〗 AAA 〖〗〖〗〖〗〖〗 0.020(0.027)〖〗-0.017(0.015)
〖 BH 〗 BBB 〖〗〖〗〖〗〖〗-0.225**(0.113)〖〗 0.018**(0.009)
〖 BH 〗 CCC 〖〗-1.087***(0.147)〖〗 0.413***(0.081)〖〗〖〗-0.966***(0.175)〖〗 1.033***(0.323)

BBB

CCC

aaa

实现

10 replies • 2023-07-30 14:03:34 +08:00

tjxwork

Jul 30, 2023

https://regex101.com/

正则表达式
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})
.*?($.*?$).*?($.*?$)
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})
.*?($.*?$).*?($.*?$)
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})
.*?($.*?$).*?($.*?$).*?($.*?$).*?($.*?$)

换行部分自己换成"\n"

测试文本
〖 BH 〗 AAA 〖〗〖〗〖〗〖〗 0.020 〖〗-0.017
〖 BH 〗〖〗〖〗〖〗〖〗(0.027)〖〗(0.015)
〖 BH 〗 BBB 〖〗〖〗〖〗〖〗-0.225 〖〗 0.018
〖 BH 〗〖〗〖〗〖〗〖〗(0.113)〖〗(0.009)
〖 BH 〗 CCC 〖〗-1.087 〖〗 0.413 〖〗〖〗-0.966 〖〗 1.033
〖 BH 〗〖〗(0.147)〖〗(0.081)〖〗〖〗(0.175)〖〗(0.323)

替换
$1$2$5$3$4$6\n$7$8$11$9$10$12\n$13$14$21$15$16$22$17$18$23$19$20$24

结果
〖 BH 〗 AAA 〖〗〖〗〖〗〖〗 0.020(0.027) 〖〗-0.017(0.015)
〖 BH 〗 BBB 〖〗〖〗〖〗〖〗-0.225(0.113)〖〗 0.018(0.009)
〖 BH 〗 CCC 〖〗-1.087(0.147)〖〗 0.413(0.081)〖〗〖〗-0.966(0.175)〖〗 1.033(0.323)

来，V 我 50

tjxwork

Jul 30, 2023

@tjxwork
https://imgur.com/a/kauwhGJ

paopjian

Jul 30, 2023

这种逻辑合并,把空格当做分隔符处理表格可以吗

28Sv0ngQfIE7Yloe

Jul 30, 2023

我觉得有比正则更好的方案

iamhrh2

Jul 30, 2023

@Morii 求方法。别的软件也行？

iamhrh2

Jul 30, 2023

@tjxwork #1
这个没看懂。EMEDITOR 能实现吗或是别的软件能实现也行。可有偿

tjxwork

Jul 30, 2023

@iamhrh2

VSCode
Ctrl+H
Alt+R 启用正则

分别粘贴

查找
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})\n.*?($.*?$).*?($.*?$)\n(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})\n.*?($.*?$).*?($.*?$)\n(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})\n.*?($.*?$).*?($.*?$).*?($.*?$).*?($.*?$)

替换
$1$2$5$3$4$6\n$7$8$11$9$10$12\n$13$14$21$15$16$22$17$18$23$19$20$24

tjxwork

Jul 30, 2023

@iamhrh2

EmEditor

查找，点 “>” 启用多行
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})
.*?($.*?$).*?($.*?$)
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})
.*?($.*?$).*?($.*?$)
(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})(.*?)(-?\d.\d{3,})
.*?($.*?$).*?($.*?$).*?($.*?$).*?($.*?$)

替换为
\1\2\5\3\4\6
\7\8\11\9$10$12
$13$14$21$15$16$22$17$18$23$19$20$24

EmEditor 这替换怪得很……

tjxwork

Jul 30, 2023

@tjxwork
EmEditor
https://imgur.com/QXbeLHR

iamhrh2

Jul 30, 2023

@tjxwork #9 确实怪。我这里面还只是示例。还有些特珠符号没放上去。刚弄半天没弄好。方便加下 Q 吗？ 35872693 。。有偿只是一点心意。