How to extact information in a bar seperated list and paste the individual items into a field

[B@Th*nG]

Hi guys,

i've got a big bar seperated list, eg:

PK001|PK002|PK003|PK004|PK005|PK006|PK007|PK008|PK009|PK010|PK011|PK012|PK013|PK014|PK015|PK016|PK017|PK018|PK019|PK020|PK021|PK022|PK023|PK024|PK025|PK026|PK027|PK028|PK029|PK030|PK031|PK032|PK033|PK034|PK035|PK036

I want to extract the bits between the bar's and paste into a field in SQL server\Access, IE:

FIELD1
PK001
PK002
PK003
PK004
etc..

Any ideas?

B@

 

[GravyMonster]

Try this:

http://hspinfo.wordpress.com/2009/08/08/funtion-to-split-any-string-contant-in-microsoft-sql-server/

 

[robbalmbra]

Split by explode

Use a function which splits by a delimiter, php uses explode to split into an array.