Split fields 2

[student4life]

How do you parse the data from:
ID POS WB
6740 41 BC W12345|W12344|W11111|W22222,,
6741 43 W99999|W88898,,

to:

ID POS WB
6740 41 BC W12345
6740 41 BC W12344
6740 41 BC W11111
6740 41 BC W22222
6741 43 W99999
6741 43 W88898


Values in WB column may very from 1 to 30-40
and every time i want to keep the original values in columns 1 and 2

any help is appreciated thanks
appreciated
thanks.

 

[Golom]

Have a look at faq701-6293. You will need to change the delimiter from "," to "|" for your data and you will need to determine the length of the longest string in "WB" so that you know how many integer values to use.

 

[student4life]

I’m new to this and will need a little more guidance from the experts,

What I am trying to do is create a Private Subroutine that will be activated via a button and the generated rows/columns will be appended to the existing table.

So this is what I was thinking.
1. A user imports a table.
2. presses the button
3. selects the table he wants to split and the data is appended to another table.

The imported table will Always be of the above format(ID, POS, WB). That format will not change, but the name of the imported table will change.
Part of the imported table will be the same. but it will have a different date/time stamp.

 

[PHV]

Have a look at Recordset (either DAO or ADODB) and the Split function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[student4life]

Golom thanks for the info.
i was trying to duplicate your post from FAQ701-1002047
and i am getting the same compile error at line

Mid$(";" & I1.Product & ";", S1.num + 1 , S2.num - S1.num - 1) AS [SubProduct]



any ideas ?

 

[student4life]

Golom i got it figured out. it took me some time but i got
thanks for the help....