Script to separate text

[Eric Number 7]

Is there a script that can separate a block of text and insert in to different fields:

ie:text field: apple,orange,banana to : field1:apple field2:orange field3:banana

thanks eric

[dbruggmann]

For your example it's quite easy:

Set Field("field1"; LeftWords("text field"; 1))

[Eric Number 7]

Spot on thanks, should have tried that , I thought it would pick up the commas...

it works thanks for your help