Alright, I'm workin freelance at the minute and have to invoice my work, I'm copying their data from their website and it comes in just a single line and I want to separate the data, spent 3 hours today coming up with VB code to separate it in batches but it was proper dodgy and only just worked. Was way too over complicated for it to just work line by line but now I've got it all sorted I want a function so that when I put them in one by one I need a routine that will just separate them, can anyone help me out?
It comes like this
and I need it separating into number, reference, agent, office, status, address, writer, date created and date modified.
I could do it everything was the same length easily but with the references, offices and address all being different lengths I'm proper struggling with it and I just thought I'd ask the seasoned programmers if they could just whip me up a bit of code to sort it out instantly.
Cheers
It comes like this
and I need it separating into number, reference, agent, office, status, address, writer, date created and date modified.
I could do it everything was the same length easily but with the references, offices and address all being different lengths I'm proper struggling with it and I just thought I'd ask the seasoned programmers if they could just whip me up a bit of code to sort it out instantly.
Cheers