1,217
社区成员




function f(byval s as string) as string
s = Replace(s, ";", ";" & vbCrLf)
s = Replace(s, "。", "。" & vbCrLf)
If Right$(s, 2) = vbCrLf Then '去掉末尾换行'
s = Left$(s, Len(s) - 2)
End If
f = s
end function
Dim s As String
s = "1:abcd;2:adfg;3:asdvc。"
Debug.Print s & "|"
s = Replace(s, ";", ";" & vbCrLf)
s = Replace(s, "。", "。" & vbCrLf)
If Right$(s, 2) = vbCrLf Then '去掉末尾换行'
s = Left$(s, Len(s) - 2)
End If
Debug.Print s & "|"
1:abcd;2:adfg;3:asdvc。|
1:abcd;
2:adfg;
3:asdvc。|