0;7;3

3;18;21

744;44;544

70;887;337

524;721;921

638;68;448

 

The above six records represent just some of the data in the field. What I want to do is separate the values in each record in an expression that holds the characters seperated by the semi-colon as follows:

 

field1 = 0, field2 = 7, field3 = 3

field1 = 3, field2 = 18, field3 =21

.......

ect

Any ideas how this can be done?