I am creating a simple tracking dbs and need to pull out information from a field and separate the values into separate fields. So from one field I want to pull out Co-op Number: "284" and put into the Co-op Number Field and so on. Any help on the function to use would be much appreciated!
Co-op Number:284 Customer Number:10xx68 Co-op Grant Used:125.00 Request Date:1/20/2014 Company :COMPANY NAME Contact:CONTACT NAME Address1:123 MAIN ST Address2: City:ANYWHERE State / Region:TX Country :United States Postal Code:77060 Telephone:123-456-1234 Fax: Email:EMAIL@EMAIL.COM
I need to have a separate Field for the Data.