Splitting delimited data from a field

[#1]

I have a field in my db that I am importing that is a string delimited by a ;

Example of data:

ID Codes

435 1;56;98

345 6;678;12

There is a function in QV that spilts my code into different fields, however I can't remember what it is (Blond moment).

Can anyone help ?????

[Anonymous · Accepted solution]

subfield

[#3]

Just the job - Thankyou blond moment over !!!!!

For anyone who is interested script is as follows :

Source_Data:

LOAD

* INLINE

[

;

Temp:

Load

ID

,

subfield

(Codes,';') as

Split

resident

Source_Data;

Drop

table

Source_Data;

Load

ID

,

Split

,

if

(ID = Previous(ID), peek('Count_No',-1)+1,1) as

Count_No

resident

Temp;

Drop

table

Temp;