在excel中解析url字符串

2 回答

• 0

  如果你总是想要第一组数字，并且两边总是有一个 = 符号和一个 & ，那么这将有效：

  =MID(A1,SEARCH("=",A1)+1,SEARCH("&",A1)-SEARCH("=",A1)-1)
  

  否则，这是一个可行的UDF . 您可以将它粘贴到Visual Basic编辑器 Alt+F11 中的常规模块中，并像任何其他公式一样使用它：

  Option Explicit
  
  Public Function FindFirstSetOfNumbers(MyRange As Range) As String
  
  Dim NumCounter As Integer
  Dim Start As Integer
  
  Start = Application.Evaluate("=MIN(FIND({0,1,2,3,4,5,6,7,8,9}," & MyRange.Address & "&""0123456789""))")
  
  For NumCounter = Start To Len(MyRange)
      If IsNumeric(Mid(MyRange, NumCounter, 1)) Then
          FindFirstSetOfNumbers = FindFirstSetOfNumbers & Mid(MyRange, NumCounter, 1)
      Else
          Exit For
      End If
  Next NumCounter
  
  End Function
  

  只需在任何单元格中键入 =FindFirstSetOfNumbers(YourRange) ，然后按 enter 或 =VALUE(FindFirstSetOfNumbers(YourRange)) 将其转换为数字数据类型 .

  回复于 2024-05-03T22:24:02+08:00
• 0

  =LEFT(MID(A1,SEARCH("id=",A1)+3,15),SEARCH("&",MID(A1,SEARCH("id=",A1)+3,15))-1)
  

  回复于 2024-05-03T22:24:02+08:00