SubstrInterpoint delete lock Revision 383033313930 (Wed Jan 18 2012 at 14:23) - Diff Link to this snippet: https://friendpaste.com/5Z1A9z8ENNl0BtDiC4B9qn Embed: manni perldoc borland colorful default murphy trac fruity autumn bw emacs pastie friendly Show line numbers Wrap lines 12345678910111213141516171819202122232425Function SubstrInterpoint(ByVal src As String) As String cr = Chr(13) lf = Chr(10) crlf = cr & lf s = Replace(src, crlf, lf) s = Replace(src, cr, lf) SubstrInterpoint = Substr(s, "・", lf)End FunctionFunction Substr(ByVal src As String, ByVal startChar As String, ByVal endChar As String) As String If (src = "") Then Substr = "" Else startIndex = InStr(1, src, startChar, 1) If (startIndex < 1) Then Substr = "" Else endIndex = InStr(startIndex + 1, src, endChar, 1) - 1 If (endIndex < startIndex) Then endIndex = Len(src) End If Substr = Mid(src, startIndex, endIndex - startIndex + 1) End If End IfEnd Function