Separate data from one field and place in separate fields

Discussion created by matttandy on Jun 4, 2014
Latest reply on Jun 4, 2014 by matttandy



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!


Field Data:


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.