Parse a record into mulitple fields

J

Jeffjarmato

I have multiple records using the same format as shown below, I want to parse
this record to create multiple fields from it. Example:

Customer | Work Order Number | Assembly Number | ETC...
Zon INC. | ZON-08001098 | 85130-00 Rev.1 |

Contents
"Customer : ZON INC.
Work Order Number : ZON-08001098
Assembly Number : 85130-00 REV.1
Target Ship Date : 1/23/2009
Work Order Qty : 1
Send Email Time : 1/9/2009 6:39:32 PM
Send Email User : yt
Comment : New assembly, please have MPI, stencil and SMT program ready. I
will update when clear to build.
"

Any help would really be appreciated.
 
H

Hanne Brenna

Jeffjarmato said:
I have multiple records using the same format as shown below, I want to
parse
this record to create multiple fields from it. Example:

Customer | Work Order Number | Assembly Number | ETC...
Zon INC. | ZON-08001098 | 85130-00 Rev.1 |

Contents
"Customer : ZON INC.
Work Order Number : ZON-08001098
Assembly Number : 85130-00 REV.1
Target Ship Date : 1/23/2009
Work Order Qty : 1
Send Email Time : 1/9/2009 6:39:32 PM
Send Email User : yt
Comment : New assembly, please have MPI, stencil and SMT program ready. I
will update when clear to build.
"

Any help would really be appreciated.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't Enter New Record in Subform 4
Parse a field into 2 fields 4
Launching a Form from Within a Form to Create a New Record 1
H E L P - Problem with 'related' table - no new record is created - why ? 2
Combine multiple rows into one record 10
How can I loop through fields in a known record 4
Parse Record with Delimited Field Into Multiple Records 1
How to normalize tables in a sales quote db with multiple quantitiesfor each part number 7

Top