Splitting Data "Text to Columns" Style

[DanAuber]

I have data in a Table like this:

Field1 Field2 Field3
ASDS 3435 UJK|HDJN|HJHJ
HJDSF 7232 ABC|KDDJ

and I want to either expand this table or make another one so that the third field is "Text to Columned" on the pipe field - the result thus being:

Field1 Field2 Field3 Field4 Field5
ASDS 3435 UJK HDJN HJHJ
HJDSF 7232 ABC KDDJ

Can anyone help with this ?

 

[lespaul]

If Access2K or above look into the SPLIT function in the help files.....

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com