seperate a string 1

[tomk01]

I have a field that looks like this: E(1),D(AB),E(12345),...

I need to pull that data into a temp table that looks like this:
DET Detcode
E 1
D AB
E 12345

I was thinking somthing like this:

select left(field,1)as detcode
into temptabel
from table;

select mid(field,3,1)
into temptable
from table
where mid(field,5,1) = ","

the problem with that is it will take a tremendous code to cover all possibilities.

any help is very appreciated

 

[lespaul]

how many numbers did you put in the table? What is the longest string you are trying to process?

Leslie

 

[tomk01]

ok I added 300 Records to my table and now it seems to work(I get data). Thank you all for your help!!!