Parse Input String and assign to field

If I import a fixed width ascii file and the records looks like this:

0123456John Smith          111 Anywhere Street              Chicago, Il  12345
1245874John Doe             245 Elm Street                         New York, NY  78945

How can I strip out the data, if I only know the start position and the length of each field and assign it to a field in my table.Start Free Trial