Split Vales from one field into multiple records

[Jalz]

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

[Zcast]

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

[Jalz]

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

[Fitch]

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

[Jalz]

Thanks Fitch

Exactly what I wanted!