ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
InputDesired output
2
[1.2.3 (a)] first topic;[1.2.3 (b)]; second topic;[1.2.3 (d)]; third topic;[1.2.5]; fourth topic
1.2.3 (a), 1.2.3 (b), 1.2.3 (d), 1.2.5
3
[1.2.3 (a)] first topic;[1.2.3 (b)]; second topic;[1.2.3 (d)]; third topic;[1.2.5]; fourth topic
[1.2.3 (a)] ;[1.2.3 (b)]; ;[1.2.3 (d)]; ;[1.2.5];
[a-z]*[a-z] [a-z]*[a-z]
4
[B3]=regexreplace(A3,E3,"")
5
1.2.3 (a), 1.2.3 (b), 1.2.3 (d), 1.2.5
6
[B5]=substitute(trim(substitute(substitute(substitute(B3,";"," "),"]",""),"[","")),") ","), ")
7
8
9
[1.2.3 (a)] First topic;[1.2.3 (b)]; Second topic;[1.2.3 (d)]; Third topic;[1.2.5]; Fourth topic
1.2.3 (a) 1.2.3 (b) 1.2.3 (d) 1.2.5
[]]|[a-zA-Z]*[a-zA-Z] [a-zA-Z]*[a-zA-Z]|[];[]
10
[B9]=regexreplace(A9,E9,"")
11
1.2.3 (a), 1.2.3 (b), 1.2.3 (d), 1.2.5
12
[B11]=substitute(B9,") ","), ")
13
14
15
[1.2.3 (a)] First topic;[1.2.3 (b)]; Second topic;[1.2.3 (d)]; Third topic;[1.2.5]; Fourth topic
1.2.3 (a), 1.2.3 (b), 1.2.3 (d), 1.2.5
[]]|[a-zA-Z]*[a-zA-Z] [a-zA-Z]*[a-zA-Z]|[];[]
16
[B15]=substitute(regexreplace(A15,E15,""),")","),")
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100