Array field in load script

[Slender77]

Hi,

I'm currently trying to dynamically convert the contents of an array field into a table. What's the best way to handle this in my load script?

The data looks like this:

DocumentID	Values
123	"AA","BB","CC"
124	"CC","BB"

and I'm trying to convert it to this:

DocumentID	Values
123	AA
123	BB
123	CC
124	CC
124	BB

Thanks for your help.

[Or]

Subfield(Values,',') will split based on a comma separator. You can use PurgeChar(Values,'"') to remove the quotes if you don't want them to be part of the separated string.

[Slender77]

Thank you! This is exactly what I was looking for.