splitting returned record field into multiple records

[k_holt69]

Hi

I need to split the following table into a more readable format in the load statement.

From this

Area	Post Sectors
A	['PE33 0', 'PE33 9', 'PE34 3']
B	['NG13 0', 'NG13 9', 'NG23 5', 'NG24 4']

To this

Area	Post Sectors
A	PE33 0
A	PE33 9
A	PE34 3
B	NG13 0
B	NG13 9
B	NG23 5
B	NG24 4

Any ideas please?

[BrunPierre · Accepted solution]

Hi, load the field like this.

Trim(PurgeChar(SubField([Post Sectors],','),'[]''')) as [Post Sectors]

[k_holt69]

Spot on thx, and really appreciate the quick response