I know this sounds very stupid and I did this when I still had my programming booths on!! However I need help please.
I have a string like this
23/03/07 11:25AM 7242 56
First note that there is two space between the time and the number 7242.
Now what I need to do is copy each section like date time the number 7242 and 56 to its own string to be put into it's own db field.
How can a specify to start copying in one position and stop at another then copy that text to another string so that I have the following at the end of the day:
txtDate = 23/03/07
txtTime = 11:25AM
txtExt = 7242
txtTrunk = 56