Prev: index.dat...Apparently I'm accessing it.
Next: How To Check If PDF File Is Security Enabled or Not
From: News on 22 Apr 2008 15:58
I use this function for a job like you have:

Record is the string
Field is the delimitter, a comma in your case
VeldNr is the count of the field you want to isolate

Attribute VB_Name = "IsolateField"
Option Explicit

Public Function GetField(Record As String, Field As String, VeldNr As
Integer) As String
'Isolate a field from a string
On Error GoTo FaultHandler
GetField = Split(Split(Record, Field)(VeldNr), ",")(0)
Exit Function
FaultHandler:
Select Case Err.Number
Case 9
Err.Clear
Exit Function
Case Err.Number
MsgBox "Fault in GetField Module: " + Str(Err.Number) + Chr$(13)
+ Chr$(10) + Chr$(10) + Error + " !", vbExclamation + vbOKOnly
Err.Clear
End Select
End Function


Regards, Akai

"Cathy" <Cathy(a)Nospam.com> wrote in message
news:13tdkv1b67sf3c5(a)corp.supernews.com...
> Thanks for previous assistance, I have now managed to install this on
> Vista
>
> I have a string in VB that contains lots of dats seprated by commas
>
> I am trying to think of a simple and easy method of extracting different
> values from this text string and placing them into variables.
>
> Any suggestions on how best to do this?
>
> TIA
>
> C
>

 | 
Pages: 1
Prev: index.dat...Apparently I'm accessing it.
Next: How To Check If PDF File Is Security Enabled or Not