New to the list

[admin]

Hi, my name is Sal and I am new to the list. I have a few questions and hope that someone can share their experience on the matter. Currently, I am working with Datastage and I have run into a few problems.

1st - I am extracting data from a sequential source, the only problem is that some records in the source file contain sub-records. For example, in the source there may be a record for an employer followed by any number of sub-records for their employees. How do I deal with this situation?
Example (sequential file):
Employer 1211 CT Supply Co Houston TX 77084 2134
Employee James Owen 1723 oak street Houston TX 77083
Employer 1212 Hunting World Houston TX 77085 2098
Employee Jason Lund 22356 pine street Houston TX 77083
Employee George Stam 1138 maple street Houston TX 77087

2nd - I need to be able to parse peoples names into different fields in the target source, namely First Name, Middle Name, Last Name. The problem is that the source files from which I am extracting the name store it in different formats(i.e. "sal hernandez", "lund, Jason", "hernandez, Jorge R", "Hector Cruz II"). Does anyone know of an external routine that does the parses the names?

Thanks for the help,
Sal