Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Public Function GetField(Packet As String, Field As String, ProcessType As Boolean) As String
  2.  
  3.     Dim Parse() As String
  4.     Dim X As Long
  5.     Dim Y As Long
  6.     Dim Search As String
  7.     Dim Delimiter As String
  8.    
  9.     Select Case ProcessType
  10.         Case 0
  11.             Delimiter = "À€"
  12.             Search = "À€" & Trim(Str(Field)) & "À€"
  13.             If Left(Packet, 4) = "YMSG" Then Packet = "À€" & Right(Packet, Len(Packet) - 20)
  14.         Case 1
  15.             Delimiter = "&"
  16.             Search = Trim(Field)
  17.     End Select
  18.    
  19.     X = InStr(Packet, Search) + Len(Search)
  20.     If X > Len(Search) Then
  21.         Y = InStr(X, Packet, Delimiter)
  22.         If Y > X Then
  23.             GetField = Mid(Packet, X, Y - X)
  24.             Exit Function
  25.         End If
  26.     End If
  27.  
  28. End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement