Hi all,

I have a field which contains data, which is seperated by carriage returns like the one below.

Apple

Orange

Banana

Grapes

Plum

Guava

What I would like to do is split the values into 6 records(in this case but could be many more).

Any advise would be much appreciated

Thanks

Jalz

Does it matter what data goes into what record? Or do you want all data going into EACH record?

No it does not matter, im just interested in splitting the values from a single field into multiple records in the same file.

Thanks

Jalz

Script something like:

 

Set Variable( $items; yourField )

Set Variable( $i; 0 )

Loop

 New Record

 Set Variable( $i; $i + 1 )

 Set Field( yourField; GetValue( $items; $i )

 Exit Loop If ( $i > ValueCount( $items ) )

End Loop

Thanks Fitch

Exactly what I wanted!