If I have a string like this "CUSTOMER: 9997|9998|9999. DEPARTMENT: 15|01|03.", minus the quotes - how would I get the 3 numbers after Customer but before Department. Plus it will not always be 3 numbers - it can be 1, 2, 3, 4, 5, etc. I would do the same for after Department but if I can see how to do it for Customer I should have no problem converting it for all the other words that I will try to find.
Plus, if I have a string like this "From JAN-01-2010 To DEC-31-2010" How do I get the Date Range in code.