I have a string formatted as follows:
2005443,"1/20050602104455/636","13/04/2006 14:49:02 ACT DWE : Printed:s80 - No Property"
I need to break this string down .... I use the split function and would not ordinarily have trouble, but because I need to break it down a little further I am getting lost a little
Using the above string as an example .... I need to break the string down into the following variables
FileNum = 2005443
ClientRef = 1/20050602104455/636
DateTime = 13/04/2006 14:49:02
Act = ACT
Author = DWE
Note = Printed:s80 - No Property
All of the strings are typed as strings except the datetime variable which is a date.
Notice the part of the string which commences with the DateTime variable is what I am having trouble with, as in my example string it is all one field.
Commented coded answers are appreciated